2 Replies Latest reply: Nov 5, 2012 5:22 PM by Jake Bingen RSS

    Load Script: Combine If Then Logic

      I would like to combine two equations into one in my load script:

       

      Load Script:

      ((IF(match(gl_revenue_account_no, 4006003),(extended_price*-1)))) AS extended_price_Commission,
      

       

      Current Equation (equation I would like to combine)

      =sum(extended_price_Commission)+sum(extended_price)
      

       

      I would like it so I can do 'blah' AS extended_price and this new value will have gl_revenue_account_no value removed

       

      Or if anyone else has any other ideas?  I would like to remove 'gl_revenue_account_no = 4006003' from the total extented_price value however this can be done within the load script.

       

      Thanks for any help.