Question Re: Mathematical Function ABS() not working in Technology Q&A

Mathematical Function ABS() not working

Former Member — Fri, 27 Mar 2015 09:53:21 GMT

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

Re: Mathematical Function ABS() not working

anshu_lilhori — Sun, 29 Mar 2015 09:33:24 GMT

can you share the formula you have written ?

Regards,

Re: Mathematical Function ABS() not working

KodandaPani_KV — Sun, 29 Mar 2015 09:59:41 GMT

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.

Re: Mathematical Function ABS() not working

Loed — Mon, 30 Mar 2015 08:29:25 GMT

Hi Nitin,

If ABS formula is not working, let's just do your own ABS formula..Let's call the keyfigure you are using as ZKF_TEST:

Create a formula, let's call it ZFORMULA_KF and enter this:

( ZKF_TEST < 0 ) * ( ZKF_TEST * (-1) ) + ZKF_TEST

Regards,

Loed

Re: Mathematical Function ABS() not working

Former Member — Mon, 20 Apr 2015 11:05:34 GMT

Hi All,

While checking the error i noticed that the formula doesnot get saved in the backend instantaneously, it takes some time to save the formulae after which it will start giving the output.

sometimes even after changing the formulae, old formulae values were appearing in the output.

Can you please suggest how can i check it ...

Regards

NitRam

Re: Mathematical Function ABS() not working

Former Member — Mon, 20 Apr 2015 11:22:14 GMT

Hi Nitin,

Can you re-generate the report in RSRT and see if you are still getting the old values.

Also try clear cache memory with the help of basis.

Regards,

Vengal.

Re: Mathematical Function ABS() not working

Former Member — Mon, 20 Apr 2015 12:14:12 GMT

Hi Vengal,

I tried regenerating the report and creating the formulae, but still the values are not working fine ..

Whenever i try using mathematical function the foumulae doesnot create/save.

Without using simple calculations using +,-,*,/ the report works fine and output is displayed properly ...

But the problem occurs when using mathematical function, data function.....

Kindly suggest...

Re: Mathematical Function ABS() not working

Loed — Tue, 21 Apr 2015 08:28:58 GMT

Hi Nitin,

How about creating your own ABS formula? Error still occurs?

( ZKF_TEST < 0 ) * ( ZKF_TEST * (-1) ) + ZKF_TEST

If you are using analyzer for queries, you may logout then login again to refresh the query being used in analyzer..

Regards,

Loed

Re: Mathematical Function ABS() not working

Former Member — Wed, 22 Apr 2015 12:52:23 GMT

Hi loed,

i need to analyze why this function is allowing the formulae to work at report level..

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

Re: Mathematical Function ABS() not working

Former Member — Wed, 22 Apr 2015 12:53:28 GMT

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

Re: Mathematical Function ABS() not working

Former Member — Wed, 22 Apr 2015 13:27:20 GMT

Hi Nitin,

Yes,i think that would be the reason. When you try without NODIM function, it was not able to interpret both A and B are of similar type(due to different base units).

Regards,

Vengal.

Re: Mathematical Function ABS() not working

Loed — Thu, 23 Apr 2015 02:08:19 GMT

Hi Nitin,

As Vengal said, you Query Designer does not allow us calculate values having different units since it doesn't make sense..

Like, adding 10 KG with 10 KL..

Regards,

Loed

Re: Mathematical Function ABS() not working

Former Member — Thu, 23 Apr 2015 08:25:27 GMT

Hi Loed,

I having this problem at web report level ..

Regards

NitinRamola

Re: Mathematical Function ABS() not working

henrique_costa — Fri, 19 Mar 2021 15:08:40 GMT

Hi.

We can solve this way:

DATA: valor TYPE i,
zval TYPE i.

zval = '-111.1'.
PERFORM abs USING zval CHANGING valor.

WRITE valor.
FORM abs USING p_zval
CHANGING p_valor.

IF p_zval LE 0.
p_valor = p_zval * -1.
ELSE.
p_valor = p_zval.
ENDIF.