Conditional Formatting when on field comparison

[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.

[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.

[owainesau]

Hi,

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

[Andrew]

Hello,

Great! Thank you for the reply.