Newbie Questions

Re: repeating table calculations (2ndary data source)

Abhishek — Thu, 20 Apr 2006 04:56:37 GMT

wow. Thank you Patrick.
:))

Re: repeating table calculations (2ndary data source)

Patrick Halstead — Thu, 20 Apr 2006 04:38:12 GMT

Thanks Abhishek for the moderating. You are now a moderator! :)

Re: repeating table calculations (2ndary data source)

Mairen — Mon, 17 Apr 2006 15:00:55 GMT

Sorry about hte double post. I accidentally put in in the wrong forum before and was trying to move it over here, but I guess I can't delete my own posts. Ah well. I appreciate your help.

Re: repeating table calculations (2ndary data source)

Abhishek — Mon, 17 Apr 2006 14:23:28 GMT

Hi Marien,

U have posted this question twice.

I have answered this in the following link.
http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2163

Regards,
Abhishek

repeating table calculations (2ndary data source)

Mairen — Mon, 17 Apr 2006 13:51:14 GMT

My form contains a repeating table that is populated from a secondary data source. The table contains two columns a "category" column and an "amount" column.

There are three possible values that could be in the category column of each row, and I have three "total" fields in another part of the form.

The idea is that one total will have the sums of all amounts that have a category of "a" , the second the sum of all amounts with category "b" the third with all amounts of catergory "c".

I tried implementing this with a Rule on the amount field that would add it's own value to "totalfielda" if its category = a. This doesn't seem to work. Since the user doesn't input the values in the reapeating table, the Rule never gets invoked.

Is there a way to do this without coding? And if not, how can I access each amount and category field in the reapeating table to perform the calculation for another field?