Is it possible to do sumif function like excel in Infopath?
B Ben Hamlin Apr 10, 2007 #2 You can do a sum() function and filter the input. For example, sum(my:myFields/my:group1/my:field1[@type="foo"]) would sum all field1 with attribute "type" being equal to foo. This is doable through UI if you don't feel comfortable writing XPath.
You can do a sum() function and filter the input. For example, sum(my:myFields/my:group1/my:field1[@type="foo"]) would sum all field1 with attribute "type" being equal to foo. This is doable through UI if you don't feel comfortable writing XPath.