Skip to Content
0
Former Member
Feb 19, 2009 at 04:44 PM

Need help with formula to calculate percent of orders <$500.

32 Views

Have data with salesperson order info. Am already counting total number of order per salesperson and also counting and summing order count of orders with order$<500. Can't figure out how to calculate number of orders per salesperson with order $ <$500 as percent of total number of orders per salesperson. Tried just dividing the two numbers, but got results that didn't make sense.