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.