Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session

Scripting calculations for subtotal and taxes = grandtotal

Avatar

Level 1

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.

layout --------------

amount

amount

amount

amount

subtotal

taxes

grand total

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

skyler

2 Replies

Avatar

Former Community Member

Sklyer,

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.

Steve

Avatar

Level 1

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%