AnsweredAssumed Answered

Using "If ... Then ... Else ..." as filter expression (PI Datalink)

Question asked by StefanH on Jul 21, 2017
Latest reply on Jul 21, 2017 by rdavin

Hello everyone!

 

Using PI compressed data within PI Datalink in Excel I came across the "If then else" function used as a filter expression. I can see what the filter expressions (Filter 1, 2, 3 and 4) are doing, but I cannot find a good explanation how it works behind the scene. It seems like putting "0" into "then" or "else" is the key here. Can someone point me to an explanation?

 

Outcomes