Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Subtotal Help

Avatar

Level 2

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?

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

0 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 10

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...

Avatar

Level 2

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