InfoPath Dev

Thanks Ernesto i got it working now. :) sum(xdXDocument:GetDOM("Work Order System")/dfs:myFields/dfs:dataFields/dfs:Work_Order_System/@Labor_Hours_Total[msxsl:string-compare(../@Labor_Min_Date, xdXDocument:get-DOM()/my:myFields/my:SummaryReport/my:LR_StartDt) >= 0 and msxsl:string-compare(../@Labor_Min_Date, ...

Yes it works without condition during preview. i attached the screenshot. totals of all items were pulled, not the correct total because we dont have condition. sum(xdXDocument:GetDOM("Work Order System")/dfs:myFields/dfs:dataFields/dfs:Work_Order_System/@Labor_Hours_Total)

Thanks Ernesto, i tried both but still the output is zero, i think your sample is not applicable for data that is coming from a Sharepoint List. I tried this but still no luck sum(xdXDocument:GetDOM("Work Order ...

Thanks Ernesto for your reply,. but i can't get the correct formula, can you help? i tried using this formula below and im getting 0.0 value for Grand Total Hours, i am filtering the repeating table base on the dates, these two dates are outside of repeating table, Start Date and End Date, sum(xdXDocument:GetDOM("Work Order ...

Hi Guys - I was able to manage to show my sharepoint list using a repeating table that i seen in different blogs. My problem now is i can't find a way to add a total column in the footer. Im filtering the sharepoint list data in my view by hiding the rows. I just want to calculate the totals of the rows that is not hidden. Any idea?