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

    Count and Sum in Script execution

    Mark Graham


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




      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;