If statement - greater than or equal

[LearnQlik]

Hello,  New to QlikSense

I created a variable (vWDR) from the following formula:

round((Sum(Cmpst_ttl_tons) + Sum(Rcycl_ttl_tons) )/(Sum(Lnd_Inc_ttl_tons)+ Sum(Rcycl_ttl_tons) + Sum(Cmpst_ttl_tons)+Sum(WCER_ttl_tons)) *100,0.5)

If the result is 100 or greater I want to sent variable vWDR to zero  otherwise I want to retain the value form the calculation.

Any ideas how to best do this?

[Channa · Accepted solution]

if(vWDR >=100 ,0,vWDR )

[cpomeren003]

Channa is correct, here some more information on how it works:
https://help.qlik.com/en-US/sense/February2019/Subsystems/Hub/Content/Sense_Hub/Scripting/Conditiona...