Absolute Value

[sona_sa]

Hi,

Please find the attached qvw file.

I have used Fabs function in my vMAPE calculation. After that all the negative sign is replacing with positive sign. But the calculation is same. But if we will see the total value of the expression it is wrong. Now it is coming 0.59. As per positive calculation it should be 0.75.

In Excel there is a function abs, which is providing the same output. i.e - 0.75.

Can any one give me the same output.

Thanks.

[danieloberbilli]

if you take away the fab() function, the result is still -0.59  ...so it seems that the mistake is not due to the fab() function.

[danieloberbilli]

This should work:

sum(aggr( Fabs((Sum(SALES_QTY) - Sum(SOP_Cts))/1000), Group, CATEGORY))

[sona_sa]

But After the calculation of  = Sum(Actual)-Sum(Plan) whatever the figure is coming, Positive or Negative --> I want to convert in Positive and then Total of all the value. i.e is 0.75.

[danieloberbilli · Accepted solution]

if you use sum(aggr( Fabs((Sum(SALES_QTY) - Sum(SOP_Cts))/1000), Group, CATEGORY))

it should result in