UnRepeated Function
Description:
Evaluate the expression as if it occurred immediately outside the repeat context in which it occurs.
When used inside a nested repeat, it has the effect of moving the context one level up (ie in a 2 level nested repeat, UnRepeated will move the context to the first level of repeat). To move the context more than one level, nest the UnRepeated functions - see the ReportDate example below
Returns:
Any
Parameter:
Parameter | Data Type | Description |
|---|---|---|
1 | Any | The expression. |
Examples:
When using functions inside a field, remember the field brackets:
Expression | Result |
|---|---|
[ Repeat CompanyCount {CompanyName} is a company within the {UnRepeated(CorporationName) } corporation.] | For each repeated Company, the value of the non-repeated variable CorporationName |
[ Repeat CompanyCount [Repeat DirectorCount {DirectorName} is a director of {UnRepeated(CompanyName) }.]] | For each doubly-repeated director, the value of the singly-repeated variable CompanyName |
[ Repeat CompanyCount [Repeat DirectorCount As of {UnRepeated(UnRepeated(ReportDate)) }, {DirectorName} is a director of {UnRepeated(CompanyName)}.]] | For each doubly-repeated director, the value of the singly-repeated variable CompanyName and the ReportDate which occurs 2 levels up (in this case outside any repeat structure) |
note
Note that in the final example, the field {UnRepeated(UnRepeated(ReportDate))} is equivalent to using NonRepeated(ReportDate) since there are only 2 levels of nesting.