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