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

    Error in if statement in load command

      Hi

       

      I am getting at if statement in below code:

       

      SalesTable:
      Load [A], sum([B]) as Revenue, if([C]=12,sum([D]),0) as Freight
      Resident Operations
      Group by [A];
      Join(SalesTable)
      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?