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





      I would like a separate table that simply sales and Commission


      Sales PersonGross SalesCommission


      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.