Re: Need function to sum Option button totals

donstephen — Thu, 05 Jun 2014 02:38:48 GMT

Hi Matt,

I understand that you are looking for a formula which adds up the sum of items having a certain type. If you are using a repeating table, then you could use a formula such as:

sum(field1[field2 = "Type1"])

where field1 is the item and field2 contains the type of item. To add this condition, click the filter button after selecting the desired field, in this case field1, and then select field2 for the frist drop down, select the condition (=), and enter the value desired.

But if you are working with non-repeating fields, then you should be able to add fields using a formula such as:

field1 + field2 + field3

Hope this helps.

Need function to sum Option button totals

MattT1 — Wed, 04 Jun 2014 20:11:29 GMT

I'm building a form with fields MaterialName, MaterialCost, and 4 option buttons to indicate the MaterialFunding source (MaterialFunding Type1, Type2, Type3 and Type4). I want to calculate the total of each of the types of funding. New to Infopath, I thought this would be an easy SumIf statement, but I'm learning there is no such thing as an Xpath IF statement. If I could use an IF statement this is what it would look like: =SumIF(MaterialFunding, 3,MaterialCost). Can anyone help me write a function that will give me a total for each option. Thanks

General

Re: Need function to sum Option button totals

Need function to sum Option button totals