Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Can anyone please assist?

Best regard Thomas

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question