How to calculate one field by another to show total in a separate field, and sum in a separate filed

Question

I have a 5x6 table. the first row consists of titles (can not be edited) and rows 2-5 are blank and can be edited.  Row1 Column1 is titled Quantity, Row3 Column3 is titled Unit Price, and Row5 Column5 is titled Estimated Amount. When editing the prepared form, each column, (1, 3, and 5) are nemed Quantity Row1, Unit PriceRow1, and Estimated AmountRow1.  I need column 5 to multiply column 1 by column 3.  I.E If I put the number 3 in column 1 and a dollar amount in column 3, i need column 5 to calculate 3 x the dollar amount and display the tot\al amount in column 5.  Additionally, I have a seperate Estimated Total field that I need to sum Column5 Row1, Column5 Row2, Column5 Row3, Column5 Row 4, and Column 5 Row5. How do I do all of this? Thank you for your help, truly appreciated.

Nesa Nurani · Answer

Select 'Prepare form' tool → right click on 'Estimated Amount' field and select 'Properties' now click on 'Calculate' tab → select 'Value is the' and where it says 'Sum (+)' change it to 'product (x)', now click on 'pick' and select Quantity and Price field for that row. Repeat above for other rows. For 'Estimated Total' field, repeat as above but leave as Sum(+) and pick other Estimated fields.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded