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!
Employee Profitablity Custom Search
I am very eager to create a custom search that I can use as a custom KPI on our company dashboard to report our technican's profitablity.
In other words I want to create a search that finds hours billed and approved by employee as well as hours actually worked by employee.
Once I have that data (we know our average billing rate as well as our average fully loaded labor rate) I want to take total hours billed*average billing rate (revenue)-total hours worked*average fully loaded labor rate (cost) to get profit and then express than result at a %.
0