AnsweredAssumed Answered

Repeating fields puzzle: how to combine two calculations in one?

Question asked by kamasoto on Jan 15, 2017
Latest reply on Jan 15, 2017 by BruceRobertson

For some time I have tried to combine two calculations with repeating fields into one calculation, without success.

• I have a FIELD_A  (10 repeating fields containing text)

• I want to know in which repeating field occurs the first time a certain TEXT

• I have build a first calculation (with 10 repetitions) CALC_TEMP = Case ( FIELD_A = "TEXT": 1 ); then a second calculation that gives the first occurrence of the TET:  FINAL_CALC = RepNumber ( CALC_TEMP ; 1 ; 1 )

 

Could this be done in one calculation, for instance with the LET function? I believe that someone could suggest a clever solution. Thanks.

Outcomes