Page 1 of 1

Conditional Formatting when on field comparison

Posted: Wed Jul 19, 2017 1:09 am
by owainesau
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.

Re: Conditional Formatting when on field comparison

Posted: Wed Jul 19, 2017 10:23 am
by HighAley
Hello.

Could you specify where do you use this expression?
Here is a sample report with such Condition.
Report.mrt
(12.02 KiB) Downloaded 391 times
If you still need our help, please, send us your report template with sample data for analysis.

Thank you.

Re: Conditional Formatting when on field comparison

Posted: Wed Jul 19, 2017 11:13 pm
by owainesau
Hi,

Thanks a lot, that worked, i swear i tried this though already :S

Re: Conditional Formatting when on field comparison

Posted: Thu Jul 20, 2017 4:35 am
by Andrew
Hello,

Great! Thank you for the reply.