1 Reply Latest reply on Apr 21, 2017 10:13 AM by gregor

    PI AF Analysis Optimization

    Doddabasappa

      Hi,

       

      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.

      Calc.png

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