topic Multiplication in a sum function in QlikView

Multiplication in a sum function

markmccoid — Fri, 03 Aug 2012 22:24:59 GMT

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

Fri, 03 Aug 2012 22:27:40 GMT

Is commision fix to 50% in every salesperson?

markmccoid — Fri, 03 Aug 2012 22:42:52 GMT

No, it's all over the place. For example if there was a sale for $100:

Sales Rep X gets 75%

Sales Rep Y gets 25%

For another sale:

Sales Rep X gets 100%

Sales Rep Y gets 100%

They do this, because the revenue is used for calculating commissions.

Thanks,

Fri, 03 Aug 2012 22:58:09 GMT

I guess, you need to have tables like

Sales [Salesperson, Place, SalesAmount]

connect it to

Commision [Salesperson, Place, Commision Rate]

So that it's easier to identify the commision rate.

It's just an idea.