Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
markmccoid
Partner - Creator II
Partner - Creator II

Multiplication in a sum function

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

3 Replies
Not applicable

Is commision fix to 50% in every salesperson?

markmccoid
Partner - Creator II
Partner - Creator II
Author

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,    

Not applicable

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.