Can anyone help me with this stupid equation.
I’m trying to figure out my parts per hour which should be as easy as 60 / production standard but I keep getting an error. My BAQ worked before I tried add this new field.
(60 / JobOper.ProdStandard) is my equation, Syntax is good. BAQ will not return any rows once I added this field. I think my issue has to do with some of my Production Standards being 0.
Divide by 0 is not a valid math calculation. You will want to change it to a conditional statement.
(case when JobOper.ProdStandard>0 then (60 / JobOper.ProdStandard) else 0 end) or something along these lines
1 Like
Thank you this worked perfectly!