Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
you mean doesnt work with the field with null value?
No, it just randomly works with some figures and not others even if they are identical.
you need to post sample file
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