InfoPath Dev

Hello I have a repeating table that is a secondary data source. That retrieves all data on open and I filter it using two dates. Then I have a second repeating table that I am using the insert command and I am performing calculations and I am filtering the repeating table the same way between the two dates. The problem I am having is my sum is being skewed by all the data vs what's only shown. I am trying to filter sum but everything I am trying is not working. I want to use something like this sum(EstPS[Title = VendorPS]) but I need current or I tried filtering like this sum(EstPS[msxsl:string-compare(NextDueDataPS, Date1) 0]) still doesn't work. any suggestions?

If you are using the Insert command from qRules - you could just copy in the rows that meet your date range.... does that solve the issue? As to your filtering - can you click the checkbox in the formula editor for sum(EstPS[Title = VendorPS]) and paste the full XPath in a reply? Oh & let me know where in the schema that formula is being used? Like - is it a calculated value in a repeating table? Or something else? :)

I like that method of only inserting the filtered rows. Can you help with how to do that?

Sure - so you are using the Insert command from qRules, then rules to populate your data? Or is this custom code?

Sorry, I am using qRules. I will attach a sample of the form to help you with that I am doing.

Cool - yah, I can def. give you a hand with this. :)

Hi Hilary, please check your email.