When the Total Actual Cost amount is a negative value, the Total Variance Cost amount is incorrectly calculated. If the Total Actual Cost amount is positive, this issue is not replicated. The calculation is performing simple math and there for when a negative amount is subtracted it is in effect adding a positive amount. [(Planned Cost) - (-Actual Cost)] is evaluated as [(Planned Cost) + (Actual Cost)].
Steps to Reproduce:
<Please see attached file for image>
Expected Result: Variance Cost = 2,000 [12,000 - |-10,000|] (we expected the calculation to use an absolute value)
Actual Result: Variance Cost = 22,000 [calculated as 12,000 - (-10,000)]
This is working as expected based on the simple cost variance formula (Planned Cost minus Actual Cost). A cost variance is considered to be a positive variance when the actual cost incurred is lower than expected. The variance is considered to be a negative variance when the actual cost incurred is higher than expected.Therefore, in the example provided, a negative 'Actual Cost' on the Financial Cost Plan is lower than the 'Planned Cost' amount is generating a positive Cost Variance amount.
Keywords: CLARITYKB, revmgr