Get(CalculationRepetitionNumber)
Category: Get
Syntax: Get ( CalculationRepetitionNumber ) |
Parameters: None
Data type returned: Number
Description:
Returns the current repetition number of a calculation field. If the calculation is not set to allow more than one value, Get (CalculationRepetitionNumber) returns 1.
Get (CalculationRepetitionNumber) is nothing more than the repetition number.
You can use the repetition number in conditional tests involving repeating fields. For instance, the following formula
If (Get (CalculationRepetitionNumber) < 4; "foo"; "boo")
returns a repeating calculation field with values foo, foo, foo, boo, boo, and so on.
Examples:
Function |
Results |
---|---|
Get ( CalculationRepetitionNumber ) |
Returns 1 in the first repetition of a repeating field, 2 in the second repetition, and so on, up to the maximum number of repetitions the field has been defined to hold. |
A calculation field defined to hold five repetitions and has the following formula
Get (CalculationRepetitionNumber) ^ 2
returns the repetition values 1, 4, 9, 16, 25.