Advanced Price List Formatting

Have more questions? Submit a request

Here is how it works:

[Name] [: display] [{ statement [; statement]}]

     (Text in square brackets is optional)

Where statement is

     Target = source [operand operator]

Where Target is one of

     PRICE – price at the level
     COMM – commission at the level
     OVER – overage at the level
     COST – cost at the level

Where source is one of:

     PRICE# - price in any of the 15 levels and # is replaced by the level. P1 is price in level 1
     COMM# - like above, but for commission
     OVER# - like above, but for the overage split
     COST# - like above, but for cost
     A decimal number like 10 or .8

Operator can only be an asterisk or a slash:

 

     Asterisk (*) – use the OASIS markup code – that is 10 is essentially converted to /.9 via the long math article, but 200 = 2X 
     Slash (/) – divide.

Operand may be any of the source values

Consider the following test:

226113_special_price_formatting.JPG

In this case, the price for level 3 is set to whatever is in price level one marked up 10% (/.9) and the commission is set to 10%.
Also, Level 4 price is set to whatever is in price level 1 divided by .8 and the commission is set to 10%.

Articles in this section

Was this article helpful?
0 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.