Need help with Sumif (or equivelant) - InfoPath Dev
in

InfoPath Dev

Need help with Sumif (or equivelant)

Last post 03-11-2014 11:44 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 03-11-2014 11:02 AM

    • tcoia
    • Not Ranked
    • Joined on 01-31-2013
    • Posts 7

    Need help with Sumif (or equivelant)

    Hi..

     Im deveolping a form, a change request assessment form to be specific. There are many users to this form, and alot of criteria to be had.

    Having said that, each "group" must assess the change for impact and level of effort. 

     If they decide there will be an effort for that group to incorporate the suggested change into their scope.  They must determine a few things.. including which project is impacted, which stage and which activity within that stage.  We are now asking the assessor to forecasting which Fiscal year the work is to be done and how much work (in hours).. This work can possible span mulitple fiscal years.

    so what I need to accomplish is easy.. (or In my head it is at least.. )   I need to add all hours that are for a particular FY..

    so total fy14 hrs.

    vs total fy15 hrs.

    the section in which they enter the data is a repeating table within a repeating section. They have the ability to enter additional items to the list.

    Seems so simple yet im so confused.

    thanks for any help you can offer. .

  • 03-11-2014 11:44 AM In reply to

    Re: Need help with Sumif (or equivelant)

    When you use the sum function, you can select the repeating field you want to sum, and then you can add a filter to it - there should be button that allows you to "Filter Data" when you select the repeating field. You'd then add a filter like "FY = 14" or some such.

    http://www.infopathdev.com/files/folders/examples/entry41116.aspx has a sample form that may be helpful - or feel free to attach a sample form under the options tab and I can help you with it.

    Hilary Stoupa

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