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

Question

Question

Showing the Sum from a column in a single line entry at the bottom of the table

Forms
Updated January 18, 2021
asked on January 18, 2021

I am trying to enter a formula that will take the values in a column in a table, and show the total in a single line entry box beneath the table. I have tried =SUM(Table.ColName) with no luck. Any ideas?

0 0

Replies

replied on January 18, 2021

Hi Cody,

First of all, check if your fields are Number and not String (your return too should be a Number field).

Then, in your Return Field, type a formula like below.

 

1 0
replied on January 18, 2021

I have plugged all of that in and it is still not working. The formula validates on refresh successfully, but when I go to test, it says there is a calculation error and will not show the totals

0 0
replied on January 18, 2021

With some more fiddling, I have figured it out. My variable was saved with a typo somehow, and it now works perfectly. Thank you!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...