I'm puzzled over the values the following example formulas return: x = ValueWhen( Ref(TimeNum()==73000,-1), TimeNum() ); Returns 73500 x = ValueWhen( Ref(TimeNum()==73000,0), TimeNum() ); Returns 73000 x = ValueWhen( Ref(TimeNum()==73000,1), TimeNum() ); Returns 72500
I thought that the Ref function used -1 to shift reference to a past value while a positive number refers to a future array value but the opposite occurs in the above formulas. Not sure why the results are opposite from expected unless I've missed something here. Any clarification much appreciated. Thanks & Regards, Dean H
