Search
Search

# ABS() calculation

Hi all

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