TECHNOTE: Worksheet Example for calculating PPA_WIP_VALUES

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

What are the computations for the fields in the PPA_WIP_VALUES table? 

Environment

Release: All Supported Versions

Resolution

Within the attached Microsoft® Excel Workbook an explanation is provided on the formulas used within the application for computing the values.  The workbook also provides you with the opportunity to enter in some sample values and see how the formulas are applied to the data entered.  

You can also refer to the following technical article for the same formulas.

 

The attached Workbook contains 3 worksheets that will help you to understand the computations for this table:

1. Formulas: This sheet provides you with the formulas for the computed values used in the application 
2. Setup: This sheet provides you with setup details for sample test cases that illustrate the application of the formulas to data entered 
3. Sample Output: This sheet provides you with a sample output generated into the PPA_WIP_VALUES table based on the sample date entered on the Setup sheet 

More Information:  

• Reference the Financial Management Guide for more information regarding financial transactions.
• Reference : What is the difference between the use of 'Actual Cost' vs. 'Standard Cost'?
• Reference : KB 22589 - How are the values in PPA_WIP_VALUES computed?  

Attachment:  Reference Link Below