I am trying to use AF Templates to create values in Event Frames. To do this I am pulling in a "tonnage/hr" value from my asset and applying that to a calculation in a formula.
The problem is if I don't have a "tonnage/hr" PI value for the asset, then the formula breaks and produces an error
Is there any way I can set up my formula to ignore these error, or somehow account for them? I have tried using an IF statement to determine if it is >0<, but that didn't work.
I have 100s of assets so don't want to create templates for each.
Thanks in advance for any assistance.