https://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/115978.aspxWed, 05 Apr 2017 12:27:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115978K5Optima0https://www.infopathdev.com:443/forums/thread/115978.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115978Hi Hilary, please check your email.https://www.infopathdev.com:443/forums/thread/115977.aspxTue, 04 Apr 2017 21:58:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115977Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/115977.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115977Cool - yah, I can def. give you a hand with this. :)https://www.infopathdev.com:443/forums/thread/115976.aspxTue, 04 Apr 2017 21:56:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115976K5Optima0https://www.infopathdev.com:443/forums/thread/115976.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115976Sorry, I am using qRules. I will attach a sample of the form to help you with that I am doing.https://www.infopathdev.com:443/forums/thread/115975.aspxTue, 04 Apr 2017 21:43:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115975Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/115975.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115975Sure - so you are using the Insert command from qRules, then rules to populate your data? Or is this custom code?https://www.infopathdev.com:443/forums/thread/115974.aspxTue, 04 Apr 2017 21:38:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115974K5Optima0https://www.infopathdev.com:443/forums/thread/115974.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115974I like that method of only inserting the filtered rows. Can you help with how to do that?https://www.infopathdev.com:443/forums/thread/115972.aspxTue, 04 Apr 2017 21:30:13 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115972Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/115972.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115972If 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? :)https://www.infopathdev.com:443/forums/thread/115969.aspxTue, 04 Apr 2017 18:36:23 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:115969K5Optima0https://www.infopathdev.com:443/forums/thread/115969.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=115969Hello 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?