Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Saved Search: Formula (Text) How to Calculate % Complete?
Hello! I'm needing help with a formula to show me % complete in a Timesheet Search.
I simply need to take (Timesheets Created / Total Team Members) * 100 = % Timesheets Completed.
But as you can see below, my numbers are off. The second row should be 100, and the third row should be 66.66
This is my results tab:
The formula (Text) I'm using is:
ROUND(((CASE WHEN SUM({totalhoursdecimal}) > 0 THEN 1 ELSE 0 END) / COUNT({employee}))*100,2)
The COUNT({employee}) is working as expected, but I'm having trouble pulling the number of timesheets that have more than 0 hours on them for the week.
Tagged:
0