Is it possible to have a calculation return its results into different repetitions.

For example: Having a calculation field with two repetitions, then have it return the "true" result of an "IF" statement in repetition [1] and "false" result in repetition [2]

Thanks in advance, as I can't find any references to this.

Mark

Ok

So, for example, we have a number field (field1) and we wish that a repeating field (Rep) shows "true" into the first repeatition if field1 > 5 and "false" into second repeatition in all other cases.

Given this is about what you wish, we need a new field (field2) with this calc:

Case(

field1 > 5;"true¶";

"¶false"

)

the calc for Rep will be:

GetValue ( Extend ( field2 ) ; Get ( CalculationRepetitionNumber ) )

The question is very confusing. One IF statement can have only one result: either TRUE or FALSE - no matter how many repetitions.

It IS possible to have different calculations going on in each repetition, e.g.:

Choose (

Get(CalculationRepetitionNumber) - 1 ;

2 + 3 ;

2 * 3

)

returns {5 ; 6}.

Thanks comment,

That's exactly what I was trying to achieve.

& thanks raybaudi, but I didn't want to have to create anymore fields.

Mark.

Hi MRH

the comment's calc always evaluates all the field repeatitions in a way that the final result isn't much like to have only a repeatition full loaded. (as I understood that you wished)