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

Question

Question

Total formula outside of table referencing columns of table

asked on May 9, 2023 Show version history

V 11

Classic Form Designer

I have several forms that use tables and have fields outside of the table that include formulas to calculate in various ways with success.  I am trying to add the amounts entered into a table on a new form without any luck.  No calculations are happening and no calculation errors display.  Is there a limit to the number of rows for calculations?  The only difference in this form vs other forms is the # of rows and the fact that I am using row headers here but not elsewhere. 

 

See below. For example, I want to sum all amounts entered into the Applicant column in the Annual Gross Income Section for the Applicant block in Total Gross Income for Each.  My formula is =SUM(ANNUAL_GROSS_INCOME_SECTION.Applicant) - it does not work.  Also, why, on this form, are the $ signs (currency field) hanging with the field label, this is not happing in other forms either.  

 

 

 

0 0

Answer

SELECTED ANSWER
replied on May 9, 2023

With that CSS - I would recommend setting the field width on the Layout page to be Large instead of X-Large.  As I tested with that CSS, here is how the different Layout sizes looked:

 

The formulas are not working because you are trying to sum single-line fields and not number fields or currency fields.

0 0

Replies

replied on May 9, 2023

I should have noticed that field type issue (facepalm).  Each of your suggestions have worked.  Thanks so very much!

 

1 0
replied on May 9, 2023

You're very welcome.

0 0
replied on May 9, 2023 Show version history

Please consider marking the question as answered.

Thank you!

0 0
replied on May 9, 2023

Regarding the formulas not working, please verify the variables for your table and your fields.  The formula doesn't look incorrect, but that is assuming the variables are correct, and if you copied from another form, it's possible the variables for this new table are different.

Regarding the dollar sign on the current fields showing above, it's likely a result of the CSS you are using for those fields.  Can you share the CSS you have applied to them and we can try to diagnose the issue?

0 0
replied on May 9, 2023

The CSS I'm using is:

.FivePerLine { width: 20%;     
               display: inline-block; }

 

The variable for the table and table fields are below: 

0 0
SELECTED ANSWER
replied on May 9, 2023

With that CSS - I would recommend setting the field width on the Layout page to be Large instead of X-Large.  As I tested with that CSS, here is how the different Layout sizes looked:

 

The formulas are not working because you are trying to sum single-line fields and not number fields or currency fields.

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

Sign in to reply to this post.