Sign Of Variable 1

[ganjass]

CR9

HI All

Is there a function that can detect the sign of a variable, ie +ve or -ve.

cheers

 

[bdreed35]

I am not sure of a funciton, but you could easily write a formula that you could turn into a custom function.

Try something like this:
@Detect_The_Sign

if {table.number} >= 0 then
    "Positive"
else
    "Negative"

Of course you can change this to return what ever kind of value you need for your situation.

~Brian

 

[Naith]

What you are trying to do is called finding the signum value. The Crystal function sgn does this.