Hi OC community
My CRF consists of a repeating group item which includes an item called NOT_GIVEN and is used in a sum calculation. The calculation is added to an item called NOT_GIVEN_COUNT which not in the repeating group, the calculation is func: sum(NOT_GIVEN).
If NOT_GIVEN_COUNT is greater than 0 the user is required to ask another question, item called REASON. The expression for the rule to check if a reason is required is; REASON eq "" and NOT_GIVEN_COUNT ne 0
The issue is the rule is not working how I would envisage, for example. I add two rows and leave NOT_GIVEN in both and press Save. The NOT_GIVEN_COUNT is calculated to 0 and REASON is blank, this should not fail validation. However this fails the validation check. My thoughts are the rule is being executed before the sum calculation is performed, does anyone know if this is true? I have tested the rule in Rule designer and works how I would have expected.
If anyone has any thoughts or suggestions I would be very grateful.