How to compute selling price from cost 192 mark up 10% = 213 ?

[#1]

Hi All

I have a table , i need to make it flexible by using only 1 table, Right now i am able compute when in singapore Currency , it can compute mark up 10% from cost with out any issue. But when i change to MR currency , i want the selling price in malaysia mark up 10%. But i am not able to modify the expression. Hope some one can advise me.

Paul

[#2]

Hi All

Enclosed my QV Doc.

Paul

[#3]

Paul,

It is difficult to interfere with the system developed by someone else. This requires a little more time to recognize and understand the assumptions and dependencies. I assume you are not the author ...?

regards

Darek

[Anonymous · Accepted solution]

Hello, Paul.

Look for

floor(ceil(FOB_SGD_SUB*RATE_P*TAX_*TRANSPORT_SUB,.5)/MARKUP_SUB, .5)

in your expression and change it to

ceil(FOB_SGD_SUB*RATE_P/LESS,.5)/MARKUP_SUB

and you'll have the value you want, although I don't know if it conforms with your business rules.

Hope it helps.

Regards.

[#5]

Hi Bruno

Yes this is what i look for. Thank.

Paul

[#6]

Hi Dariuzs

You are right the expression is develop by the help of this forum. which i slowly expend alone the way to make it more flexible and more powerful. Yes it is not easy to understand other people script.

Paul