2 Replies Latest reply: Jul 2, 2013 5:02 PM by Traci Dukes RSS

    Group and summarize output into a single record.

      What is the quickest way to summarize a single column from multiple rows of data input.

      In a very early verison of expressor this was simple.

      I am struggling to find it in expressor 3.7

       

      My scenario is I multiple payroll records per employee by job title.  I want to group them by social and write one output record summing the wage amount and the hours columns.

       

      What would be the simplest approach.

      I have spent alot of time trying to do something that seems like it should be simple.

      Thanks Traci