Re: Need help with Sumif (or equivelant)

Hilary Stoupa — Tue, 11 Mar 2014 18:44:31 GMT

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.

Need help with Sumif (or equivelant)

tcoia — Tue, 11 Mar 2014 18:02:32 GMT

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. .

General

Re: Need help with Sumif (or equivelant)

Need help with Sumif (or equivelant)