Issue with the absolute result calculation
We have an issue with the calculation of result for Abs Case.
Record, Actual, Forecast, Abs Difference
1. 500, 300, 200,
2. 0, 300, 300,
Result, 500, 600, 500,
Total of Abs Difference in the report is coming as 500, Actually this should be 100. (i.e 500 -600)
We have a Calculated key figure for Net diff = Actual u2013 Forecast,
Abs difference is the abs(Net Diff).
Please advise how to get the total as 100.