• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Advanced Pricing using Formula

MPSSIVYE

Member
Hi All,

I am trying to use a formula to create a surcharge on top of a base price. I create advanced pricing name called SURCHARGE.
The calculation of surcharge is 17.87-20=-2.08. As long as the calculation returns a negative there price adjustment should stop. If it cannot stop,
it should write as zero. But if it positive, then the number will be apply as surcharge.
Is there a way to do this. I am using World A9.2

Any help would be very much appreciated.

Thanks
-ivy-
 

MPSSIVYE

Member
I need to add on how i do the above.
I have created a price adjustment called FMMTSCGPD. It is calculated based on AAPD - UP001 * 1.17
If the value returns is negative, i would like the adjustment to write 0. If value is positive, accept the value.
AAPD is a variable table that is updated on monthly basis. UP001 is also a variable table that contains fixed amount.

Any one has any ideas?
 
Hi
can you try by below formula?
max(max(min(x|0)0)x)

in x you can define formula for variable table calculation.
in x value is -1
you will get 0

if it is 3
you will get 3


i have not tested it & I am not sure if function functionality is available in World.

Regards,
 
Top