any chance you are dividing by zero?
# suiteanalytics
j
any chance you are dividing by zero?
s
not 100% sure but read that it could be that. not sure though how I would process that and still be useful to the report
m
Copy code
case when {quantity} = 0 then 0 else {quantytshiprecv}/{quantity} end
s
thanks @Mike Robbins ! had to do it like this, instead of directly dividing
👍 1