Next Segment Value and Previous Segment Value |
Returns the next or previous segment value.
Parameter | Description |
Last Value | The starting segment value |
Segment | The segment number |
Level | Enter a P to return the next or previous parent value, enter a C to return the next or previous child value or leave the parameter blank to return the next or previous segment value irrespective of whether it is a parent or child. |
Book | Optionally enter a set of books id to bind the formula to a specific set of books. If this parameter is omitted, the set of books currently selected in the Set of Books dropdown list will be used. |
Example = Next_Segment_Value(“1000”,3,P)