3 Replies Latest reply: Aug 3, 2012 6:59 PM by Bill Ringer Salalima RSS

    Multiplication in a sum function

    Mark McCoid

      In our product we are able to give sales reps percentages of sales.

       

      So, if a sale is made for $100, sales rep x may get 50% and sales rep y may get 50% of the sale.

       

      It may even happen that each rep will get 100% of the sale.  Since this is for commission purposes the client isn't worried about double dipping.

       

      I'm getting incorrect results (larger numbers than I should)

       

      Here is my expression:

       

      SUM(Revenue * Rep_Percentage)

       

      The weird thing is that all of the Rep_Percentage numbers are 1, so I'm not sure how I could screw up that expression.

       

      Can someone give me an idiot check!

       

      Thanks