Need to define formula like if condition in report

[Former Member]

Hi.

I need to define a formula like if condition... in report.

Example.

A = X - Y

B= IF A < 10 THEN A ELSE '-'.

i need to calculate A using two values.

While calculating B i need to compare with A values.

if value A is less than 10 the B = A else B = -

Kindly help me.

Thanks & Regards

Jagannadha Raju.

Edited by: Venkata Jagannadha Raju Dantuluri on Sep 19, 2008 4:08 PM

Edited by: Venkata Jagannadha Raju Dantuluri on Sep 19, 2008 4:10 PM

[Former Member · Accepted solution]

Hi

you can use this formula

B = ( A < 10) * A + (A >= 10) * 0

Pls reply if you need further details

Thanks & Regards

Rohit

[Former Member · Accepted solution]

Hi

I think, you need the following

If A is less than 10, B=A else B= -A.

you can use this formula

B = ( A < 10) * A + (A >= 10) * A*-1.