Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
harjedalskok
Creator
Creator

Expressions Issue

Hi,

Im trying to create a expression that states the following

If the listprice divided by the salesprice is more or equal to 112.5 %  then the amount above should be mutilplide by 1.30 if not then multipled by 1.0

ive started but got stucked pretty fast.

If(((Sum(lägstapris)/Sum(Försäljningspris))<=('1,125')), * '1.30' )

Im kinda in a stress in this matter.

Thx in advance

/André

13 Replies
harjedalskok
Creator
Creator
Author

this is a new bonus system that give the salesman 30% extra when they salesamount is 12,5 % above listprice.

prieper
Master II
Master II


So the formula is

(SP - LP * 1.125) * 1.3?

Peter

harjedalskok
Creator
Creator
Author

No, since the difference between salesprice and listprice renders a percentage depending on that percentage some action will be taken, if the salesman have a percentage of 1,125 meaning he has sold for 12,5 % over the listprice, this doesent render anything extra for the salesman except the normal bonus, but if the sales would have been 1.25 % this means that the salesman should have an extra of 30 % on the amount above 1.125.

SP 50000 LP 40000 diffrence 10000 equal to 25 % above LP 12,5 % of the above results in 5000 that he should have an extra of 30 % on meaning that the salesman will get on that kitchen 1500 % on bonus base sales, since the kitchen in the bonus calculation will have a value of 51500 instead of the normal 50000.

Roop
Specialist
Specialist

I think that this is what you are looking for ....



If(((Sum(lägstapris)/Sum(Försäljningspris)) <= 1.125,

     Sum(Försäljningspris) + ((Sum(lägstapris) - Sum(Försäljningspris)) * 1.3,

     Sum(Försäljningspris)

)