I have created some efficiency data within EXCEL, which obviously, is very easy to use with multiple cells. I want to transition the formula in a Pi Calc, but as you are aware, the calc has to be an entire string. The result of the below expression is erratic because a small bottom end changing by the smallest amount multiplies and escalates. In EXCEL, I included a digital OR state for an inlet gas valve, so, for the ('Power_Tag'), i set to 0 when valve was closed. Can anyone advise on where I'd include this digital state into the below formula please?
To be honest, I understood the general idea but I would need a numeric example to understand better your issue. Are you trying to write an expression for PI Performance Equation? If so, this is how you would add a condition for when the PI Tag ba:active.1 is on the active state: