Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Hi All
Enclosed my QV Doc.
Paul
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
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.
Hi Bruno
Yes this is what i look for. Thank.
Paul
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