General

Re: summing up amount from specific category in dropdown menu

warrtalon — Fri, 29 May 2009 19:55:18 GMT

Create a new data element in your main data source using the Whole Number or Decimal data type. Place it on your canvas as a text box. Double-click the box and set the default value by clicking the Fx button. Click Insert Function, choose Sum, double-click "insert field here", choose the Hours node of your repeating group, click Filter, and set the filter to when the Category node equals training. This should sum all the hours from the repeating table for that category.

Re: summing up amount from specific category in dropdown menu

Andlar — Fri, 29 May 2009 18:37:15 GMT

No I haven't. I'm pretty new at infopath so I've been learning as I go. If you could explain to me the steps on how to do that it would be a great help. I'm using infopath 2007.

Thanks.

Re: summing up amount from specific category in dropdown menu

warrtalon — Fri, 29 May 2009 18:22:08 GMT

Have you tried logic, such as sum hours where category = training?

summing up amount from specific category in dropdown menu

Andlar — Fri, 29 May 2009 15:51:47 GMT

I've build a form with a repeating table which has a dropdown menu with different categories. What I'm trying to accomplish is to populate a different field with the total amount of hours inputted when that category (training) is selected and omit the other category in the total.

I hope this is clear enough.

Thanks