I
Ivan Wilson
I have a form with a repeating section. There are two numbers in each row -
Original and Updated.
I want to highlight to the user if the sum of both of these columns is
different.
I don't have any problems adding an Expression box to sum each of these
columns correctly. However, if I try to use conditional formatting to
colour-code the totals if the values do not match, things start going funny.
Just adding a new blank row causes the conditional formatting to believe
that the totals do not match.
Here is the expression that I'm using in conditional formatting. Any
suggestions on why this would not work?
sum(.../my:AmountUpdated) - sum(.../my:Amount) != 0
Original and Updated.
I want to highlight to the user if the sum of both of these columns is
different.
I don't have any problems adding an Expression box to sum each of these
columns correctly. However, if I try to use conditional formatting to
colour-code the totals if the values do not match, things start going funny.
Just adding a new blank row causes the conditional formatting to believe
that the totals do not match.
Here is the expression that I'm using in conditional formatting. Any
suggestions on why this would not work?
sum(.../my:AmountUpdated) - sum(.../my:Amount) != 0