Issue with the absolute result calculation

[Former Member]

Hi Gurus,

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.

[Former Member]

Check in the properties of the calculated key figure, the total calculation should be "nothing defined". I guess the total calculation is actually "summation".