on 2015 Mar 27 9:53 AM
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
Request clarification before answering.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
| User | Count |
|---|---|
| 9 | |
| 7 | |
| 6 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.