Subtotal Help

[zann1313]

Any chance that someone 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?

[Former Community Member · Accepted solution]

You will have to give each cell in the table a name .....I named each cell in the salary column salaries. This allows me to use a FormCalc expression that will reference the multiple Rows.salaries element. Look at the line of code on the Total field for Salaries. I will leave it to you to do the rest.

Paul

[Niall_O_Donovan]

Hi,

I would give each cell in a row a name in the hierarchy view. Then apply that name in each row.

The row total is Formcalc and is:

salaries + benefits + service + computerSoft + computerHard + travel

Then the column total uses the fact that the row names are the same (Row1), FormCalc:

$ = Sum(Row1[*].salaries[*])

I would right align the currency cells.

Hope that helps,

Niall

...snap...

[zann1313]

Let me try this out. Thanks for your advice.

Susann K. Wenzl

Office Associate IV

Curriculum, Instruction, and Innovation Team

Nebraska Department of Education

301 Centennial Mall South

Lincoln, NE 68508

Phn: 402-471-6692

Fax: 402-471-0117