Negative values as '0'

[mohan2391]

hi

how can i display negative values as 0.

For ex: I have a list box of AMOUNT, which is having +ve & -ve values together. Now I want to replace all the -ve values with 0.

[sunny_talwar]

May be in the script:

If(AMOUNT < 0, 0, AMOUNT) as AMOUNT

[Mark_Little]

Hi,

In script as Sunny as suggested.

If you want to on list. use an expression (Same as what is above)

If(Amount < 0, 0, Amount)

Mark

[mohan2391]

how to write this in set analysis

[sunny_talwar]

What is your expression currently?

[Gysbert_Wassenaar]

rangemax(Amount,0)