19 Replies Latest reply: Jul 22, 2015 11:44 PM by jagan mohan rao appala RSS

    Count and Sum in Script execution

    Mark Graham

      Hi,

      Can someone help me in getting the count() function executed

       

       

      Load

      Place, Building, Location, Units, Bridge, Barcode, Units, Bay,  Position, Level, Position&Level as PL, Bay&Location as BL

      from table1;

       

      I wanna get the Count(Barcode) by Place

                              Count(Barcode) by BL

                               Count(If(Units>0, Barcode) by Place

                               Count(If(Units>0, Barcode) by BL

                              Sum(Units) by Barcode;