General

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

Hilary Stoupa — Wed, 29 Jul 2015 22:17:43 GMT

I just sent you an email via the forum. You can reply w/ your form attached. :)

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

powersma — Wed, 29 Jul 2015 21:58:44 GMT

I went ahead and added a repeating table, it's not a problem at all! But, now it says the file is too big to attach.

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

Hilary Stoupa — Wed, 29 Jul 2015 21:52:24 GMT

Oh! Sorry, I just assumed your data was in a repeating table. How is it currently structured?

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

powersma — Wed, 29 Jul 2015 21:45:59 GMT

I don't have the information in a repeating table - do you want me to set that up first?

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

Hilary Stoupa — Wed, 29 Jul 2015 21:08:50 GMT

No - I just used a filter based on a field value to do the grouping. Attach a copy of your form under the options tab and I can set up something similar there.

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

powersma — Wed, 29 Jul 2015 20:45:40 GMT

First, thank you for your quick reply and solution!! I'm fairly new at this and not always sure I'm doing things the most efficient way. So, we have 3 GL accounts and about 80 cost centers that they can combine. Do I need to create every possible combination in the drop-down in the account Number field for it to filter to?

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

Hilary Stoupa — Wed, 29 Jul 2015 18:52:04 GMT

Here's a sample with a guess at what you're wanting. Save the file locally. Right click the file and select Design to open in IP designer. From there, preview, add some rows and take a look at the summary table. It is the same repeating table, just with some calculated values and formatting.

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

powersma — Wed, 29 Jul 2015 18:36:54 GMT

So sorry! InfoPath 2013 and filler form. Thank you!

Re: I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

Hilary Stoupa — Wed, 29 Jul 2015 16:05:57 GMT

What version of InfoPath? Browser or Filler form? I'll put together a quick sample for you later today. :)

I have an expense form table with multiple rows and need subtotals for account numbers. It needs to ignore blanks.

powersma — Wed, 29 Jul 2015 15:58:26 GMT

I don't even know where to begin, and I'm not a programmer...help please!

7110-785-= $60.00

6723-785=$16

6952-414=$6.00