Matching data from 2 tables in an expression

[#1]

Good morning, I am trying to write an expression that colours a field in a table if 2 sets of data match :-

=if(sum(Cleared_Paid)>=sum(Amt_Latest_Default_Notice),RGB(0,0,255),RGB(190,0,0))

This expression works for the most part but doesnt always work for reasons unknown.

Can anyone help with a better idea?

Paul.

[#2]

you mean doesnt work with the field with null value?

[#3]

No, it just randomly works with some figures and not others even if they are identical.

[#4]

you need to post sample file

[jonathandienst]

Hi

Are both fields associated in the same way with the dimensions in your chart? Have you tested the two sum expressions in the chart?

If you post a sample and/or screen shot, it would help to diagnose the problem.

Regards

Jonathan