General

Re: Issue on Repeating table summation

Richter Belmont — Mon, 09 Sep 2013 11:51:26 GMT

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

Re: Issue on Repeating table summation

Richter Belmont — Mon, 09 Sep 2013 08:13:43 GMT

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)

Re: Issue on Repeating table summation

Hilary Stoupa — Fri, 06 Sep 2013 21:27:00 GMT

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.

Issue on Repeating table summation

Richter Belmont — Thu, 05 Sep 2013 09:47:35 GMT

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