Calculation field based on repeating field
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