cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Mathematical Function ABS() not working

Former Member
0 Likes
3,587

Hi

The ABS Function is not working for the formulae created in the report. The values is getting subtracted, but '-' value is not getting removed from the final output.

Can anyone suggest how to proceed further.

Regards

Nitin

View Entire Topic
KodandaPani_KV
Active Contributor
0 Likes

Hi,

if you use the ABS funciton it will remove the -ve vlaues

I have one sales keyfigure and which is having +ve -ve values, but I need all values in +ve only so I use  Absolute Value, ABS ( 'Sale').

-Phani.

Former Member
0 Likes

Hi Phani,

On further analyzing the issue i found that, using NODIM function in the formulae the values are coming right.

so ..

Formulae : ABS('a'-'b')   - is not working fine.

Formuale : ABS(NODIM('A')-NODIM('B')) is working fine....

Can this be because the Base unit of keyfigures are different and which would lead to this error while calculating values on the fly from the infoprovider .

Regards

Nitin