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

InfoPath Dev

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

Last post 07-29-2015 03:17 PM by Hilary Stoupa. 9 replies.
Page 1 of 1 (10 items)
Sort Posts: Previous Next

  • 07-29-2015 08:58 AM

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

    Capture.PNG
    Reply Contact

    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 

     

  • 07-29-2015 09:05 AM In reply to

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

    Mark as Answer
    Reply Contact

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

    Hilary Stoupa

  • 07-29-2015 11:36 AM In reply to

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

    Mark as Answer
    Reply Contact

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

  • 07-29-2015 11:52 AM In reply to

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

    summary.xsn
    Mark as Answer
    Reply Contact

     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.

    Hilary Stoupa

  • 07-29-2015 01:45 PM In reply to

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

    Capture.PNG
    Mark as Answer
    Reply Contact

     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?


  • 07-29-2015 02:08 PM In reply to

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

    Mark as Answer
    Reply Contact

     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.

    Hilary Stoupa

  • 07-29-2015 02:45 PM In reply to

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

    Mark as Not Answer
    Reply Contact

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

  • 07-29-2015 02:52 PM In reply to

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

    Mark as Not Answer
    Reply Contact

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

    Hilary Stoupa

  • 07-29-2015 02:58 PM In reply to

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

    Mark as Not Answer
    Reply Contact

     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.

  • 07-29-2015 03:17 PM In reply to

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

    Mark as Answer
    Reply Contact

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

    Hilary Stoupa
Page 1 of 1 (10 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.