AnsweredAssumed Answered

Calculation field based on repeating field

Question asked by HB on Feb 14, 2015
Latest reply on Feb 16, 2015 by philmodjunk

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

Outcomes