Conditional Formatting when on field comparison
Posted: Wed Jul 19, 2017 1:09 am
Hi,
I have two fields, both integer values and i am trying to set conditional formatting on one of the fields if it is greater than the other.
Ive tried using an expression like: {invoiceData.totalInv > invoiceData.YTDTarget}
But it just prints the expression rather than the value in the field itself. If i use Field Is - Value, i dont know what to put in the greater than or equal to field.
I have two fields, both integer values and i am trying to set conditional formatting on one of the fields if it is greater than the other.
Ive tried using an expression like: {invoiceData.totalInv > invoiceData.YTDTarget}
But it just prints the expression rather than the value in the field itself. If i use Field Is - Value, i dont know what to put in the greater than or equal to field.