Code

Re: Sum a field if it meet a condition

Jimmy — Sat, 08 Jan 2011 15:31:49 GMT

Try removing all those quotation marks.

Re: Sum a field if it meet a condition

pluttod — Sat, 08 Jan 2011 14:01:45 GMT

i added an expression box with the following "sum("@Maor-count[@Facility=site]")" and i get the follow error

Expected alue type end-of-string

Actual value: name

"Sum("--->dfs:dataFields<---/d:SiteDashBoard-2/@Major-count[../@Facility = ../../../my:site]")"

Sum a field if it meet a condition

pluttod — Fri, 07 Jan 2011 12:51:54 GMT

can you run a SumIf statement in a inforpath form. Ihave a form that i insterted a sum field in the footer of the repeating table, which I have a date filter applied to. Howeer it the sum field sum all of the records not the filtered records. I understand why I'm getting this result, because the filter only effects the display of the record and does not remove it from the record set. so the question is can i sum on the filtered data