CAS 6


next
- Sequential

Summary

Get next (nth) ordered item. If ordering is not specified get from next physical record. If last item in group, result is 0 or blank.

Examples

next LOANBAL DATE LOANID
2 next LOANBAL DATE LOANID (PROPTYPE in 'SF')

Syntax

(ItemNumber) next TimeSeries (Order) (Group|SelectionStatement)

Left Arguments

Name Data Type Input Type Description Optional Default
ItemNumber Numeric Field, Constant Step Yes 1

Right Arguments

Name Data Type Input Type Description Optional Default
TimeSeries Numeric Field Time series No
Order Date Field Sort Field Yes
Group Text Field Grouping Yes
SelectionStatement Boolean Field, Constant Selection Yes

Result

Type: Numeric

Input field shifted by n



Build 6.0.624