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.