Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a straight table with expressions. One of my expression is returning positive and negative amounts.
I need the negative amount to be set at 0€.
Is it possible to do it in the Number / Format tab ?
(I know I can put an "IF" in my expression to say "If amount < 0 then 0 else amount" but I want to avoid IF in my expression.
Thanks for your help
Laure
With out IF i don't think it is possible
Try this
RangeMax(YourExpression, 0)
Without using if you can use mapping load in the script part and may those values and make calculation on the script part.
Hope this helps
Regards
Anand
It might be, using RangeMax()
Thanks it works