Steve... attached is the file I am having issues with.
Solved! Go to Solution.
Views
Replies
Total Likes
You need to turn on "Expand to fit" for the height of the Description field on the Layout palette.
Views
Replies
Total Likes
You need to turn on "Expand to fit" for the height of the Description field on the Layout palette.
Views
Replies
Total Likes
Thanks, Jono!
I didn't know that option was available. Any chance that you might be able to help me develop a subtotal button that when clicked gives subtotals for each column for the table in the activity subform of the attached file?
Views
Replies
Total Likes
I would just have the table total as it goes, much easier I think than trying to put it all into a button. And it's quite easy to do with FormCalc but you need to make sure you name your fields properly then you can use wildcards in the formula for your rows and columns.
As you'll be able to see in the attached, I've named the first couple of rows of cells - the Administration row I've named all the cells "admin" and you'll see that LiveCycle has added an instance number in brackets because they've got the same name. Using FormCalc in the Calculate event of the Total cell the formula is sum (admin[*]) - add up all cells named "admin" on this row. I did the same with the Community row.
The same works for totalling columns, except you use the wildcard on the instance of the Row instead of the field (again you need to watch the naming, the Rows all need the same name). I've named some of the Total column cells "total". The formula for the total in the bottom right cell is sum (Row1[*].total) - add up all cells named "total" from every row named Row1.
Hope that helps!
Thank you. You explained this very well. I appreciate all of your help.
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies