Expressions Issue

[harjedalskok]

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é

[robert_mika]

Try this:

If((Sum(lägstapris)/Sum(Försäljningspris))>=1.125,Sum(lägstapris)/Sum(Försäljningspris)) * 1.30,Sum(lägstapris)/Sum(Försäljningspris))

You do not need to multiply by 1 as will give you the same result.

[jyothish8807]

Hi Andre,

Is it what you are looking for?

IF((LP/SP)>='112.5%',((LP/SP)-1125)*1.30,(1125-(LP/SP))*1.0)

Regards

KC

[aveeeeeee7en]

Hi

Try this:

If(Num((Sum(lägstapris)/Sum(Försäljningspris)),'#,##0%')<='112.50%',(Sum(lägstapris)/Sum(Försäljningspris))*1.30,

(Sum(lägstapris)/Sum(Försäljningspris))*1.0)

Hope that works

Regards

Av7eN

[#5]

Hi,

=if((sum(listprice)/sum(salesprice))>=112.5,(sum(listprice)/sum(salesprice))*1.30,(sum(listprice)/sum(salesprice))*1.0)

[PrashantSangle]

Hi,

Try

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

(Sum(lägstapris)/Sum(Försäljningspris))*1.30,

(Sum(lägstapris)/Sum(Försäljningspris))

)

regards

[jyothish8807]

I think I took your statement  " amount above " in wrong sense.

IF(sum(LP)/sum(SP)>='112.5%',sum(LP)/sum(SP)*1.30,sum(LP)/sum(SP))

Regards

KC

[#8]

Hi,

What do you mean by "amount above"? I am assuming it as sum(ListPrice)/sum(SalesPrice).

Could you please try using it:

if(

(sum(ListPrice)/sum(SalesPrice))*100 >=112.5,
(sum(ListPrice)/sum(SalesPrice))*1.3,

(sum(ListPrice)/sum(SalesPrice))

)

[prieper]

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

should do (please check decimal-symbol to be either "." or ",".

HTH Peter

[harjedalskok]

Hi,

Thx for fast response, im gonna try the above, just to clearify, its only the amount above 1,125 that should be multiplied, so the expression should give the result,

lets for say that the salesprice is 50000 the list price is (100%)40000 then the first (112,5 %) 45000 should be multiplied with 1.0 the rest (12,5 %) 5000 should be multiplied by 1.30 giving a result of 51500.

so the extra gain for the salemans bonus is 1500 since he sold the kitchen 25% above list price.

Hope this sorted some of the thoughts