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!
Views
Replies
Total Likes
What's the criteria that triggers a subtotal to be needed?
Views
Replies
Total Likes
I need the breakdown for records, but I don't want to make it a pain for users.
Views
Replies
Total Likes
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[*])
Views
Replies
Total Likes
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
Views
Replies
Total Likes