Something like this:
var Totalprice = (StringToNumber(Field("Itemprice")) +
StringToNumber(Field("TAX"))) *
StringToNumber(Field("QTY"));
return FormatNumber("$.00", Totalprice);
Or maybe:
var Totalprice = (StringToNumber(Field("Itemprice")) *
StringToNumber(Field("QTY"))) +
StringToNumber(Field("TAX"));
return FormatNumber("$.00", Totalprice);
(I'm not sure if the "tax" amount is for each item or for the subtotal.)
Dan
-----Original Message-----
From: [EMAIL PROTECTED]
Hi All,
I'm trying do make a invoice with tax and total price calculation.
I have a lot of items priced without tax in the database.
Item Intemprice QTY TAX Price
x 20 3 ?$ ?$
y 30 7 ?$ ?$
Totalprice ?
I'm using FP 5.0P1b
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
Users of FusionPro Desktop have unlimited free email support. Contact Printable
Support at [EMAIL PROTECTED]
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm
--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--
--
Note: All e-mail sent to or from this address will be received or otherwise
recorded by the e-mail recipients of this forum. It is subject to archival,
monitoring or review by, and/or disclosure to someone other than the recipient.
Our privacy policy is posted on www.printplanet.com
--
