How to use less than and = function

[vikas_nandanwar]

Hi,

Expression for less than and equal to function

I want a logical  condition as

If Sum of Amount is less than zero then zero else sum of Amount

Column name as Amt

thanks

Vikas

[tresesco · Accepted solution]

RangeMax( Sum(Amt), 0)

If you want to understand using IF, try like:

If( Sum(Amt)<0, 0, Sum(Amt) )

If ( <condition>, what when true, what when false)

[Anil_Babu_Samineni]

Or

If(Sum(Amount) < 0, 0, Sum(Amount))

[vikas_nandanwar]

Thanks This worked