4 Replies Latest reply: Sep 11, 2012 6:43 AM by Jonathan Dienst RSS

    Matching data from 2 tables in an expression

      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.