3 Replies Latest reply: Jan 20, 2016 10:26 AM by Srikanth P RSS

    sum total sales

    Tomer Biran

      Hi


      I created a straight table  with  3 dimensions (Worker Name ,ID , WRH ) in order to calculate the employee evaluation  bonus

      the evaluation bonus = (monthly branch sales)*(manger's employee evaluation - percentage)

      as follows :

       

      worker name

      ID

      WRH

      SALES

      mangers evaluation

      BRANCH _TOTAL _SALES

      BONUS

      A

      1

      25

      1000

      30%

      1000

      300

      B

      2

      32

      2000

      10%

      5000

      500

      C

      3

      32

      3000

      30%

      5000

      1500

      D

      4

      57

      500

      15%

      1500

      225

      E

      5

      57

      1000

      85%

      1500

      1275

       

      I have an issue with the sum expression of  the monthly branch sales ,

      i am not sure what to use...

      as the  example table above :


        i would like the sum branch sales  field to consist all  the sales of the employees from the same branch ,

       

      C

      3

      32

      3000

      30%

      5000

      1500


        5000=3000(sales -B)+2000( sales-C)
       
      can someone assist ?