InfoPath Dev

Hi Guys - I want to share my problem here hoping that someone can help me resolving :)

Im doing a sum in a repeating table, sum all "hours" and "amount" that are same WONum field. However, the hidden rows with the same WONum is also adding up, can someone knows how to prevent those hidden row from summing up? Thanks.

WO60001 = should be 3.5hrs only
WO60002 = should be 9hrs only
WO60007 = should be 0.5hrs only



here is the code i put..

sum(/my:myFields/my:LaborReport/my:_Hours[../my:_WONum = current()/../my:_WONum])

 Hi - you need to add to the XPath the filter you are using to hide some rows.

sum(/my:myFields/my:LaborReport/my:_Hours[../my:_WONum = current()/../my:_WONum and ../my:SomeField != "SomeValue"])

I don't know what you are filtering on, so the XPath and value in bold above are made up - but that is the general idea.

Thanks Hilary It Works!

sum(/my:myFields/my:LaborReport/my:_Hours[../my:_WONum = current()/../my:_WONum and msxsl:string-compare(../my:_Date, ../../my:SummaryReport/my:LR_StartDt) >= 0 and msxsl:string-compare(../my:_Date, ../../my:SummaryReport/my:LR_EndDt)

Do you know how to filter the date thru code?

xIter = MainDataSource.CreateNavigator().[Select]("/my:myFields/my:Group1/my:LaborReport[@_Date >=
../../my:SummaryReport/my:LR_StartDt and @_Date <=
../../my:SummaryReport/my:LR_EndDt]", NamespaceManager)

doesnt return anytthing