You are viewing limited content. For full access, please sign in.

Question

Forms table calculation for total

Forms

Updated June 20, 2023

asked on June 20, 2023

Hello,

I'm trying to come up with a formula to total up a column within a table. The table will have a varying number of rows so depending on how many Activity Fees are added. Has anyone done something like this? I need to add all of the Vendor Quote fields together at the bottom in the form in the Total field. Thanks.

ActFee.JPG (37.04 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on June 20, 2023

You should be able to use the SUM function on the total field after the table.

It'll look something like this:

=SUM(table_variable.vendor_quote_variable)

1 0

replied on June 20, 2023

Thanks. I tried this earlier but I must have had a variable wrong. Its working.

1 0

Replies

replied on June 20, 2023

If you are expecting multiple rows you will need to add the ROW() piece. I have a similar setup and I use this. I just inserted your table.field in the example

=SUM(table_variable.vendor_quote_variable,ROW()="0")

0 0

You are not allowed to follow up in this post.

Question

Question

Forms table calculation for total

Answer

Replies

Sign in to reply to this post.