lower/higherFlag - the keywords

lower or

higher denote whether the value from the next lower/higher matching

record must be taken if no related record is found

Returns the value specified in sourceField using the

relationships in the

relationships graph. LookupNext is similar to

Lookup, except that when the lookup fails, the value from

sourceField in the lower or higher matching record will be returned, as specified by

lower/higherFlag.

For this function to access the value in sourceField, the

tables containing the source field and

calculation field need to be related. Calculations using the

LookupNext function won’t be forced to be

unstored calculations.

The Rate Lookup calculation field will return

25,

25,

100, and

150 for records 1 to 4.

Rate Lookup can then be used to get the correct rate code (A, A, C, and D respectively).