tinhx7

Line Items Calculations

Discussion created by tinhx7 on Jan 8, 2018
Latest reply on Jan 12, 2018 by tinhx7

Hi guys,

 

My payroll/commission is base on Line Items table.

I need some suggestion for this complex commission.

Here's my services menu:

 

Category 1             Category 2               Category 3

Service A                   Service A                  Service A

Service B                   Service B                   Service B

 

Category 1 & 2 commissions are either 60-40% or 50-50, and Category 3 is sometimes 60-40, or 50-50.

I can calculate 60-40 across the board fine. But what's the best way to calculate commission of Category 1, 2, and 3 together ?

 

ie: service A (cat 1) $15

   service B (cat 2) $12

    service A (cat 3) $10

 

60% of $15 = $9

60% of $12 = $7.2

50% of $10 = $5

Total:          $21.2

Outcomes