Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be in the script:
If(AMOUNT < 0, 0, AMOUNT) as AMOUNT
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
how to write this in set analysis
What is your expression currently?
rangemax(Amount,0)