Discussions
SuiteWorld is the largest annual gathering of the NetSuite community! It will be held in Las Vegas on October 6-9, 2025. Our customers and partners look forward to SuiteWorld every year as a place to hear the latest from NetSuite, get hands-on learning, and connect with each other. Register now!
Now, you can stay up-to-date with the latest discussions, helpful tips, and important announcements, all delivered straight to your inbox. Whether you’re looking to catch up on what you missed or just want a quick overview, our email digest has you covered. To learn more and to subscribe, click here.
How to create a percentage per employee for actual time against the subtotal?
Hi NetSuiters,
I am trying to build a report that displays for each employee the time spent per Business Units (class). I have currently build the following report which gives the actual time in absolute value and the total actual time per employee.
For the next step, I would like to have and additional column with the actual time in percentage relative to the subtotals ( = total for one employee). So the idea would be to get the following:
employee X:
BU1 100 hours 67%
BU2 50 hours 33%
Total employee X 150 100%
employee Y:
BU1 150 hours 75%
BU2 50 hours 25%
Total employee Y 200 100%
Currently, I have only been able to get the percentage based on the total hours worked by all employees which is not the objective.