InfoPath Dev

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

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]")"

Try removing all those quotation marks.