AnsweredAssumed Answered

Hello All, what can I do to return a zero value i.e "0.00" for a null value of a ratio of (IF badval('PI_TAG_AVG') THEN "0.00"  ELSE ('PITag_1'*'PITag_2')/('PITag_2'))

Question asked by Bille Champion on Nov 30, 2017
Latest reply on Nov 30, 2017 by Sam Pride

Hello All, what can I do to return a zero value i.e "0.00" for a null value of a ratio of (IF badval('PI_TAG_AVG') THEN "0.00"  ELSE ('PITag_1'*'PITag_2')/('PITag_2'))

Outcomes