I have a work form that lists cost of work preformed. 4 amount fields, a subtotal field, tax, and grand total. I am having an issue collaborating the subtotal, taxes and grandtotal. I have googled everywhere just for basic FormCalc help but to no avail. Any help you can give me will be very much appreciated.
this is the script I foolishly 'thought' would work.
Subtotal - Sum(AMOUNT, AMOUNT, AMOUNT, AMOUNT)
Tax - Sum(TOTAL * .0825)
Grandtotal - SUM(TOTAL, TAX)
I have ran the syntax check on all fields no errors, but I get some extremely weird output when integers are place in the amount fields.
they are all numeric fields (i don't know if all this is relevant but I'm trying to make this as easy as possible for you to troubleshoot)
thanks in advance
The attached is a sample using FormCalc for what you are trying to achieve. In the future you should post requests in the LiveCycle Designer ES forum if the request does not include Barcoded Forms ES. The Designer forum is monitored more closely.
That puts a 8.25% tax plus the original price and then adds the two together to give greater than 100.00 value ... I have made this a bit easier but I can never get exactly 8.25% its always around 8.3 to 8.5%