Revenue is not calculated correctly in Process Configurator.
I am trying to calculate revenue using the Process Configurator.
Due to certain circumstances, I cannot use the completion rate as is, so I tried to calculate the revenue amount by multiplying the contract details amount by the planned value set for the cost/task using the following formula.
—
(( "ContractLineDescriptiveNumberFlexfield1" "ContractLineAmountinContractCurrency") + ((( "ContractLineDescriptiveNumberFlexfield1"-1)("ContractLineAmountinContractCurrency" ( "CalculationLevelNonlaborBurdenedCostinProjectCurrencyITD" / ("ContractLineLevelPlannedBurdenedCostinProjectFunctionalCurrency") ) )) -1))- "CalculationLevelEventAmountinContractCurrencyITD"
—
We have set a planned cost of 6,000,000 for the representative task used to register planned costs.
The actual cost was 2,000,000.
The contract line amount is 6,000,000.
Therefore, 0.3333...% (actual cost/planned cost) × 6,000,000 (Contract Line Amount) should equal 2,000,000.
However, when we checked the actual revenue distribution, we found that the planned value had been calculated at twice the amount, and the revenue amount was incorrect.