Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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é
this is a new bonus system that give the salesman 30% extra when they salesamount is 12,5 % above listprice.
So the formula is
(SP - LP * 1.125) * 1.3?
Peter
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.
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)
)