I read all your interesting emails. Everyone agrees that it isn't easy to determine what's most important. Factors such as employee salary, the priorities of the company (is it sale$ or the number of sales they make) are all different.
So let's put that all aside and say that my client has picked the one factor that is the most important to them in terms of weighing the profit%. Let's say that they pick the profit$ as most immportant. I could simly sort the RBase report by profit% DESC, and then profit$ DESC: Salesman1 $1,500 40% Salesman2 150 40 Salesman3 2,000 38 Salesman4 1,500 38 But again this doesn't look fair because Salesman3 was clearly more 'productive' than Salesman2! So here's my final question on this. Is there a formula where I can 'weigh' the profit% by the profit$ so that it gives me a number that is comparable between all 4 of these guys! Karen ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
