2 Replies Latest reply: May 17, 2012 4:53 AM by anubankar RSS

    Error in if statement in load command



      I am getting at if statement in below code:


      Load [A], sum([B]) as Revenue, if([C]=12,sum([D]),0) as Freight
      Resident Operations
      Group by [A];
      Load [SO] as [A], sum([Sales]) as SalesValue
      Resident Sales
      Group by [SO];


      I have declared 2 tables: Operations and Sales and now joining these two table by field [A].

      Can someone suggest how to write if statement?