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.