1 Reply Latest reply: Jun 15, 2015 4:34 AM by Onno van Knotsenburg RSS

    LOAD SUM Invalid expression

    E F

      Getting  Invalid expression  error when loading sum expression in script

      Thanks

      "Invalid expression

      INVOICES:

      load *,

      FAMILYDES as FamilyTot,

      EFAMILYDES as EFamilyTot,

      INVQuant as TotINVQuant,

      InvSellPriceNIS/InvExchangeUSD AS InvSellPriceUSD1,

      InvSellPriceNIS/InvExchangeEURO AS InvSellPriceEURO1,

      InvSellPriceDNIS/InvExchangeUSD AS InvSellPriceDUSD1,

      InvSellPriceDNIS/InvExchangeEURO AS InvSellPriceDEURO1,

      TotInvSellPriceNIS/InvExchangeUSD AS TotInvSellPriceUSD1,

      TotInvSellPriceNIS/InvExchangeEURO AS TotInvSellPriceEURO1,

      Sum(INVQuant) as [INVQuant Total]

       

      Resident INVOICES1

       

      Group By FAMILYDES , EFAMILYDES

      Order By FAMILYDES , EFAMILYDES"