3 Replies Latest reply on Apr 30, 2013 6:16 AM by Shawn Wallwork

    Calculate Total based on Row Level %

    Audrey Perullo

      I am trying to calculate Hours Collected by Employee, thier Manager and thier Region. The data is organized such that each row is an employee and thier details (manager, region, % contribution and total hours). Hours collected ( % contribution * total hours) is the calculation that I need shown. I am struggling because each employee is at a different percent, so a row calculation must be done rather than SUM(% contribution) * SUM(Total Hours).

      Any suggestions?

       

      Capture.PNG