Formatting of numbers on receipt

Mar 22, 2006 2 Replies

I have created a new receipt based on the standard receipt.xml



In addition to showing the extended full price (Entry.ExtendedFullPrice ), I want to show the extended MSRP as well. The formula for that is (Entry.Item.MSRP * Entry.Quantity).



However, most of the results of this formula will be a number with no cents (such as 489.00). The receipt automatically strips off the zeros, so it prints on the receipt as 489



If I just print the MSRP by itself, the decimals will print, but the calculation of MSRP * Quantity screws things up.



How can I format this so it always prints two decimal places.


Bill Yater The Worth Collection snipped-for-privacy@worthltd.com



You first need to define and set the value to a variable and use the vbCurrency type.

Entry.Item.MSRP * Entry.Quantity

Then place the variable in the ROW: "MSRP|" ExtendedMSRPValue

Rob

Thanks, Rob! That was exactly what I needed, and it tells me a lot about the XML format they're using.

Bill Yater The Worth Collecti> You first need to define and set the value to a variable and use the > vbCurrency type.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required