Question

Adding Rows in a Table together without JavaScript

How To Forms

Updated May 30, 2019

asked on May 23, 2019

Can someone please point me in the right direction for the correct function on this problem? I am new to tables and would like to get a total of all the rows into the Currency Field shown below.

I am currently running Laserfiche version 10.3.1.635

0 0

Answer

SELECTED ANSWER

replied on May 30, 2019

Solved! Thank you Jason. I was not getting any errors. When I looked for the variables the table was not populating with the variable name given. I closed out my form and started a fresh session to forms and everything is showing up correctly. The function I was using now works. I was not waiting for the correct variable name to populate in the function box.

I appreciate your help.

0 0

Replies

replied on May 23, 2019

Open the field editor for the Currency field, add SUM() function and put the table column variable inside of the sum function.

For example,

=SUM(Table.Column)

0 0

replied on May 30, 2019

Thank you Jason. I have tried that but have not been able to make it work. under function in the field editor I have put =SUM(Table.Cost) and I have tried just =SUM(Table.Column)

My Column name is Cost and the Table variable is Table. Any other suggestions? I know I am missing something here.

0 0

replied on May 30, 2019

Are you getting a syntax error or anything like that?

Also, make sure that your column variable is a Number type.

0 0

SELECTED ANSWER

replied on May 30, 2019

I appreciate your help.

0 0

You are not allowed to follow up in this post.

Question

Question

Adding Rows in a Table together without JavaScript

Answer

Replies

Sign in to reply to this post.