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
BedrockMission!

Learn more

View all

Sign in to view all badges

Calculate group subtotal in repeatable table with drop down menus

traskj
Level 2
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.

Thanks!

4 Replies
Scott-Mc
Level 2
Level 2

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

traskj
Level 2
Level 2

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

traskj
Level 2
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.

Sum(Table1.Row1.Cell3[*].Cell9[*])

traskj
Level 2
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

endif