5 Replies Latest reply: Mar 16, 2012 6:47 AM by Lav Jain RSS

    Problem on expression using <total> for calculating percent of time

      Hello,

       

      I have a problem with expression calculation.

       

      I have three empoloyees, EmpA, EmpB and EmpC. I also have three activities, ActA, ActB and ActC. Each employee works on an activity and I get the total hours by using the expression sum(HoursWorked). I also calculate the % of hours the particular employee worked on a specific activity. The results are fine until I make a selection of an employee where the % of hours worked changes to 100% instead of remaining to the percentile it was prior to the selection. For caclulating the % I use the expression: sum(HoursWorked)/sum(total <Activities> HoursWorked).

       

      Any help will be appreciated.

       

      Thanks,

       

      --John