JoelBrabant

Substitution of bad values

Discussion created by JoelBrabant on Jul 3, 2009
Latest reply on Jul 6, 2009 by RJKSolutions

When calling methods like InterpolatedValues/TimedValues or TimedCalculate (from the IPICalculation), is there a way to replace (not filtering) any Bad Values by the previous last good value or a substition value we would pass?  I will code it if I have to but I was wondering if I could do that in a single call.

 

03-jul-2009 06:00:00    100.00

 

03-jul-2009 06:01:00    OverRange

 

03-jul-2009 06:02:00    150.00

 

would give me

 

03-jul-2009 06:00:00    100.00

 

03-jul-2009 06:01:00    100.00

 

03-jul-2009 06:02:00    150.00

 

Also, when doing a call with TimedCalculate with expression "if Tagval(mytag) <30 then 0 else Tagval(mytag)" the value OverRange would be replaced by 100.00 before the expression is evaluated.

 

 

Outcomes