9 Replies Latest reply: Aug 1, 2012 2:44 AM by Bernardine Sanchez RSS

    error with group by

    Alec Harf

      Hi,

       

      I have the following table:

       

       

       

      LOAD

          RecordId as %LeaseKey,

          Sum(CustomFieldValue) as PlHeadcount,

          If(CustomFieldValue > 1, 1, 0) as PlIsTreatAsHeadquarters

      RESIDENT

          tblCustomFieldValue

      WHERE

          CustomFieldLabel='Headcount (Current)'

      Group by %LeaseKey ;

       

      I am getting an error that cannot find %LeaseKey.

       

      Anybody can help.

      Thxs,