Hello,
I've run into another snag with the issue of RTMC tables and digital displays requiring different syntax for expressions (please fix this CSI!). I am trying to write an expression which finds the 24 hour change in the average of three snow depth sensors. I've got it working in a digital display with the following expression (line breaks added since the forum sometimes cuts off lines):
StartRelativeToNewest(nsecPerDay,ordercollected);
Alias(X,"Server:CUES_CR3K#2.SNOW_DEPTH.WindMast_depth");
Alias(Y,"Server:CUES_CR3K#2.SNOW_DEPTH.Plat_sno_depth");
Alias(Z,"Server:CUES_CR3K#2.SNOW_DEPTH.RemoteBoom_depth");
((ValueAtTime(X,TimeStamp(X),nsecPerDay,$"Error"))+
(ValueAtTime(Y,TimeStamp(Y),nsecPerDay,$"Error"))+
(ValueAtTime(Z,TimeStamp(Z),nsecPerDay,$"Error")))/3
I tried that in a table with no success. I seemed to recall tables not being able to use aliases or StartRelativeToNewest so I tried the following beast:
(("Server:CUES_CR3K#2.SNOW_DEPTH.WindMast_depth"+
"Server:CUES_CR3K#2.SNOW_DEPTH.Plat_sno_depth"+
"Server:CUES_CR3K#2.SNOW_DEPTH.RemoteBoom_depth")/3)-
(((ValueAtTime("Server:CUES_CR3K#2.SNOW_DEPTH.
WindMast_depth",TimeStamp("Server:CUES_CR3K#2.
SNOW_DEPTH.WindMast_depth")
,nsecPerDay,$"Error"))+
(ValueAtTime("Server:CUES_CR3K#2.SNOW_DEPTH.Plat_sno_depth",
TimeStamp("Server:CUES_CR3K#2.SNOW_DEPTH.Plat_sno_depth"),
nsecPerDay,$"Error"))+
(ValueAtTime("Server:CUES_CR3K#2.SNOW_DEPTH.
RemoteBoom_depth",TimeStamp("Server:CUES_CR3K#2.
SNOW_DEPTH.RemoteBoom_depth"),nsecPerDay,$"Error")))/3)
That hasn't worked either. Is this possible? I tried to use the Virtual Data Source in RTMC-Pro 4 to see if that would make any difference, but it hasn't seemed to.
Thanks for any assistance,
Alex
* Last updated by: Clayton on 1/21/2013 @ 5:06 PM *
I forgot that you need to replace
"Server:CUES_CR3K#2.SNOW_DEPTH.WindMast_depth" with simply the table's "Original Label," "WindMast_depth". Another annoying difference between using tables and digital displays in RTMC.