3 Replies Latest reply: Feb 24, 2012 11:57 AM by mrpjspencer RSS

    How do I add wildmatch results together?

      Good afternoon, I am trying to add these fields together to get a total output. Qlickview is not liking the code even though it makes sense to me. i'm trying to get the total value for the field <Amount>

       

       

       

      if(wildmatch(Rate_Category, 'M*'),Amount) as Measured_Value,    

      if(wildmatch(Rate_Category, 'A*'),Amount) as Assessed_Value,

      if(wildmatch(Rate_Category, 'U*'),Amount) as Unmeasured_Value

        

      sum(Measured_Value)+sum(Assessed_Value)+sum(Unmeasured_Value) as sum_total