Hello,
This is continuation to my last question.
I have 4 fields which are read only where I am doing calculations with the help of Confiforms Rules for Field Definition (set expression) as follows-
Field 1: Average value of fields A, B, C
Field 2: Average value of fields D, E, F
Field 3: Average value of Field 1 and Field 2
Field 4: Priority ranks given based on value in Field 3 like if Field 3 is 1, then P1, if Field 3 is greater than 1 & less than 2, then P2 etc.,
Every time I hit submit and check the results, the Field 4 priority ranks vary. Sometimes its coming out as expected and other times its not. What can I do here to fix it?
Please help.