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

Calculate group subtotal in repeatable table with drop down menus


Level 2

Afternoon all:

I have a dynamic form with an expanding table format. There are nine columns and one of them has a drop down list of six items, the last column is a value.

I need to subtotal the six dropdown menu items separately- preferably in FormCalc.

The grand Total works just fine. 

It seems like it should be easy enough, but I'm stumped. Any help would be appreciated.


0 Replies


Level 2

What's the criteria that triggers a subtotal to be needed?


Level 2

I need the breakdown for records, but I don't want to make it a pain for users.


Level 2

I may not have asked the question correctly. I have a drop down list with 6 items. The user fills in the quantity and rate after selecting the item. I can create a row value and a grand total value. What I need to do is display the group total for each drop down item ina  separate box.

I cannot figure out how to reference the dropdown item. The menu list is tied to Cell3. I get this far, and then I am stumped.



Level 2

This code pulls out the value perfectly on the first row, but does not work on the repeating rows. What am I missing?

If(Table1.Row1.ddl[*] == "1" )then Sum(Table1.Row1.Cell9[*])

else $ = 0