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.