Prices and tax

 The only time you may need to do more than this is when dealing with prices. To include a price on a label or form you could just select the iSell_price field from the list provided by the Item_table. However, this will result in the display of more decimal places than you would probably require, so it is more likely that you would need to limit the display to 2 decimal places. To do this push the “Synthesised” radiobutton then enter

Deci(iSell_price,2) in the box underneath then push the OK button.

 

 

This will result in the display of the selling price (excluding tax) to 2 decimal places.

If you want to display prices including sales tax on the labels, then instead of the Synthesised string Deci(iSell_price,2) use the string

Deci({Mult({Divi({Add_(Tax_rate,100.00)},100.00)},iSell_price)},2)

Which adds the price and the tax and then corrects to 2 decimal places. (Hint: You can copy the string from above and paste it into the Text element properties box).