Hi Guys,
I am new here hope you can help me.. I have a repeating table and i want to compare field1>field2 and will display true or false in field 3 as well as I created a rule that will populate a "Greater than" value in field4 and if less than the field4 is blank..
Scenario i created my first entry 2 and 1 the field 3 is true and my field 4 value have "Greater than" then when I click insert item field4 is empty
the problem I encounter is that when click Insert item or update a new item values I cannot retain the field 4 values to Greater than.
If all field3 values is/are false then field 4 must be blank
if field3 contains true then field 4 = Greater than
I want to achieve OR formatting where if contains true the field 4 values must have a "Greater than" values and I want to retain the "Greater than" values even if i Insert or update as long as field 3 contains true status..
Hope you can help me achieve this I upload my .xsn