11 Replies Latest reply on Jan 15, 2017 12:59 PM by BruceRobertson

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

    kamasoto

      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.