2 Replies Latest reply on Feb 16, 2015 8:35 AM by philmodjunk

    Calculation field based on repeating field

    HB

      Title

      Calculation field based on repeating field

      Post

      I am not getting the results I expect.

      In one common table, I have many fields, 2 of which are as follows:

      Mats Reverse Bevel  is a field which has 7 repetitions, contains text which happens to be either "Reverse Bevel" or is empty.

      BR_MatCutStyle  is a calculation field which has 7 repetitions, and contains the following formula:

       

      If ( Mats Reverse Bevel = "Reverse Bevel"; "REV"; "Bevel")

      The results for the calculation for the repetitions having the text "Reverse Bevel" is "REV" as expected, but I get an empty string returning for the calculations based on the repetitions that are empty, whereas I had expected "Bevel".

      Please help - thanks in advance