AnsweredAssumed Answered

Expression To Ignore No Data Sections

Question asked by Cannon on Mar 5, 2019
Latest reply on Mar 8, 2019 by Rhys Kirk

I have several tags that while in use they will send information, but when not in use will send "NO DATA". I'm trying to do a conditional state with these tags, but since it's not sending data I can't use them. So I try to set up a calc to turn them into a 0 or a 1.

IF (tag1)>0 then 1 else 0 or IF (tag1)<>"NO DATA" then 1 else 0 but neither work. The first will just give 0 while the second just gives no data. Anyone else know how to work around the no data problem?

 

P.S. I used greater than 0 because when I try to trend them pi sets the scale at 0 being no data.

Outcomes