Skip to Content
0
Former Member
Sep 19, 2008 at 05:33 PM

Formula to determine the sign of a number

32 Views

Hi All,

Can anyone please give me an idea to write the formula for the following logic in BEx?

If X is negative then display zero

If X is positive then display zero

these are for 2 different formule to check if a particular field has a negative number it should be posted in one column and if the number is positive it should be posted in the other column.

Thanks

Prasad