8 Replies Latest reply: Feb 23, 2012 10:32 AM by mrpjspencer RSS

    Writing an expression that encompasses data in 2 tables

      I am trying to formulate an expression that encompasses data from two tables:-

       

      Table1:

      Amount,

       

       

      Table2:

      if(wildmatch(Rate_Category, 'A*'), 'Unmeasured',

           if(wildmatch(Rate_Category, 'U*'), 'Unmeasured')) as Unmeasured,

           if(wildmatch(Rate_Category, 'M*'), 'Measured') as Measured,

      I am trying to get an amount for Unmeasured and Measured in seperate fields.

      Paul.