6 Replies Latest reply: Jun 8, 2017 12:10 PM by Paul Chittenden RSS

    Calculating Commission per period, summarised per individual

    Paul Chittenden

      I have hopefully simplified my problem with calculating commission per period, but just showing a Total

       

      I can show the commissions on a sale, per salesperson, per period.

       

       

      PeriodSales PersonGross SalesCommission
      JanuaryMary£1,00050

       

      FebruaryMary£2,000£150
      MarchMary£5,000£450

       

       

      I would like a separate table that simply sales and Commission

       

      Sales PersonGross SalesCommission
      Mary£8000650

       

      Whilst i can simply do Sum(Gross Sales) for Gross Sales.

       

      Because the Commission is say 5% on the first £1000 per month, then 10%.  I need to out commission per period, then Sum the totals

       

      What function should I do to get the Commission to work it out per period, then total?

       

       

      Thanking you in advance.