I have a problem regarding the mathematical function: Absolute value.
I have a report which shows the Forecast accuracy. I will first show you the outcome:
Material/Delivered/Forecast/Diff/ABS Diff/Forecast Accuracy
A/ 150/ 160/ 10/ 10/ 93%
B/ 200/ 175/ -25/ 25/ 88%
C/ 125/ 130/ 5/ 5/ 96%
TOTAL/ 475/ 465/ -10/ 40/ 102%
To give the right result in the "ABS Diff" column I have set: Calculate result as: Summation
However: The problem is when I calculate the "Forecast accuracy" The result is correct in the material lines BUT not in the total. The total 102% is calculated based on the result of ABS Diff before setting summation. I.e. -10 and not 40.
I have tried formula collision and I have made a calculated key figure for trying to solve this but the result is the same.
I know I can solve this by using a workbook, but it is not good enough since the customer have to be able to show the profit center, the material group etc. in the report!
I have looked through threads regarding this issue but no one have yet given the solution
Can anyone please assist?
Best regard Thomas