Code

Re: Sum on Repeating Table

infopathdude — Wed, 26 Sep 2012 14:55:27 GMT

As always, thank you.....

Re: Sum on Repeating Table

Hilary Stoupa — Wed, 26 Sep 2012 14:31:50 GMT

The conditional formatting on the repeating summary table was the issue - here's a revised version.

Re: Sum on Repeating Table

infopathdude — Tue, 25 Sep 2012 20:13:54 GMT

Posted as advised..Thank you for ur help

Re: Sum on Repeating Table

Hilary Stoupa — Tue, 25 Sep 2012 19:33:59 GMT

You can attach it to a post under the Options tab - I'll try to take a look later today or tomorrow morning.

Re: Sum on Repeating Table

infopathdude — Tue, 25 Sep 2012 18:56:23 GMT

sum(/my:myFields/my:group1/my:group2/my:field2[../my:field1 = current()/../my:field1 and ../my:Code = current()/../my:Code])

I have extended the infopath template what you had sent me, but cannot find a place to send this to you..Please advise if there is a way for me to send this....

Thanks for your prompt response

Re: Sum on Repeating Table

Hilary Stoupa — Tue, 25 Sep 2012 16:01:10 GMT

What's the full XPath of your formula? You can check the Edit XPath box in the formula editor...

Re: Sum on Repeating Table

infopathdude — Tue, 25 Sep 2012 14:06:24 GMT

Hilary,

You helped me on this before....I have to extend this a tad bit and I thought I should be able to do figure this out by myself :(

I need to add an additional column to the repeating table and the sum depends on two fields now

For Eg-Expense Detail Repeating Table

Rental | A |-$10

Food | A |-15$

Hotel | B |-$50

Food | B|-$20

Misc | A |-$30

Hotel | A |-$50

Rental | A |-$10

I want the summary section to go thru the repeating table, pick these expense categories and summarize them as

Rental | A |-$20

Food | A |-$15

Food | B |-$20

Hotel | A |-$50

Hotel | B |-$50

Misc | A | $30

I tried to change the Sum filter to say sum(amount[exptype=exptype and code=code]) but it doesnt seem to add values of same code and type like shown above...it just shows the amount from the first exptype

Any thoughts on what am I doing wrong?

Re: Sum on Repeating Table

infopathdude — Wed, 22 Aug 2012 17:25:24 GMT

Hilary, thanks a ton...that was so simple...forgot abt current function

Re: Sum on Repeating Table

Hilary Stoupa — Wed, 22 Aug 2012 15:47:53 GMT

There's a sample form here that I think will help you.

Sum on Repeating Table

infopathdude — Wed, 22 Aug 2012 14:19:35 GMT

Guys, I have been using infopath for a while and I always find challenging implementing basic functions...I rem I had to perform a division on couple of fields and had some tough time...I think it was just me once i figured it out...:(

Well today I am struck with a new issue which i thought would be no issue..Trying to write an expense report form ...Have a repeating table to enter expense details

Now after all the expenses are entered i need to group them by expense categories and show the sub total for each category in a separate section

For Eg-Expense Detail Repeating Table

Rental-$10

Food-15$

Hotel-$50

Food-$20

Misc-$30

Hotel-$50

Rental-$10

I want the summary section to go thru the repeating table, pick these expense categories and summarize them as

Rental-$20

Food-$35

Hotel-$100

Misc-$30

How do I accomplish this, trying to do this in browser enabled forms

I have read about preceeding-sibling,following-sibling,eval but don't seem to figure out where to start...

Preceeding sibling will only tell me the last expense category, seems like i need to be able to iterate the repeating table to get the groupings...

Also not sure how does the preceeding functions impact when you try to insert an entry in the middle of the table ..

Please help