Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
if(vWDR >=100 ,0,vWDR )