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)



      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.