AnsweredAssumed Answered

How to condition the "calculated data" from PI Datalink with If statement of excel?

Question asked by Davidjcamilo on Apr 25, 2019
Latest reply on Apr 29, 2019 by VasanthakumarR

Hello Pi community,

 

I'm looking for some help on how i can take one calculated data together with the "IF" statement of excel. The problem is that I have one variable that I need the average of temperature per hour but only if the equipment is indicating that is ON.

Is something like: =IF("TagON/OFF"="ON",advcalcdata average for the tag of temperature)

 

Wishing the best for all the community,

 

D.C.

Outcomes