IF and ABS condition statement in BEX query designer

[Former Member]

Hi,

I would like to ask the best way for me to produce an acceptable result from Excel IF and ABS Condition statement.

The condition statement that I have on my Excel file is

=IF((A2-B2)>0,ABS(A2-B2),0)

I'm trying multiple times to reproduce this in BEX Query designer, unfortunately I'm getting a bad result or unacceptable formula.

Anyone who could help me with my issue?

Thanks,

Arnold

[ccc_ccc · Accepted solution]

Hi Arnold,

Thank you,

Nanda