Our full technical support staff does not monitor this forum. If you need assistance from a member of our staff, please submit your question from the Ask a Question page.


Log in or register to post/reply in the forum.

MinRunOverTime and -6999 in RTMC


Clayton Jan 9, 2012 10:42 PM

Hello,
Is there an expression or other method for ignoring the -6999 value which is generated by null values? I am trying to do a MinRunOverTime Digital Display in RTMCpro and occasionally we have -6999 values which are throwing it off.

Thanks,
Alex


tmecham Jan 11, 2012 04:47 PM

Have you looked at IIF? Here is an example of using the last value instead of the -6999 in a min run over a day with temp avg.

Alias(X, "Server:CR1000.HOUR.Temp_F_Avg"); StartRelativeToNewest (nsecPerDay, OrderCollected ); MinRunOverTime(IIF(X = -6999, last(X), X), Timestamp(X), nsecPerDay)

* Last updated by: tmecham on 1/11/2012 @ 9:49 AM *

Log in or register to post/reply in the forum.