AnsweredAssumed Answered

PI AF Analysis Optimization

Question asked by Doddabasappa Champion on Apr 21, 2017
Latest reply on May 1, 2017 by Roger Palmen



Need to calculate percentage of uncertainty, given expression is as below.


Uncertainty = 100*(# of times XXX.PV is bad, uncertain, limit)/43200

# of times =SUM(IF(OR(IF(XXX.PV=BAD,1,0),IF(XXX.PV=Uncertain,1,0),IF(XXX.PV=limit,1,0)),1,0))


I have achieved this in Analysis, but used intermediate tag to store count. This has to be implemented to lot of controls and there are many similar calculations which needs us to create intermediate tags.


I would like to know is there any better way to write this expression to avoid intermediate tag.