https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/123037.aspxTue, 26 May 2020 15:21:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123037Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/123037.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123037Adding the status to the filter on the XPath for a sum formula, for example, would look like: sum(xdXDocument:GetDOM("Callup_DC")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW[d:Vendor = current()/d:Vendor and d:ContractStatus != "Cancelled"]/d:TotalContractValue)https://www.infopathdev.com:443/forums/thread/123036.aspxTue, 26 May 2020 15:10:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123036Froman0https://www.infopathdev.com:443/forums/thread/123036.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123036so rather than filter the formulas which I cant seem to do, I've create a calculated column that takes the status and returns a yes/no for cancelled. then i added a button on the form to query for status, put rules on the button to set the query field value to "active" and a query rule. so cancelled shows up in the counts and formulas, but when I hit the button it queries my list for active files. this seems to be a long way around, but it works :)https://www.infopathdev.com:443/forums/thread/123035.aspxFri, 22 May 2020 20:00:22 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:123035Froman0https://www.infopathdev.com:443/forums/thread/123035.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=123035Hi Hilary, I'm trying to apply a filter to some formulas that I have inside my repeating table, but I'm coming up empty-handed. I've tried filtering inside the formula, outside of it, rules on the table and using query fields, but nothing I've tried works. In the table that returns from the Call-up list I would like to not include any Call-ups that have the status of "Cancelled". I put a rule on the repeating table to Hide if the status is cancelled, but it doesn't appear to work properly if a vendor has some cancelled and some not, sometimes it works and sometimes it doesn't, not sure why. the bigger issue is that i am unable to filter out cancelled items from the count and sum formulas i'm using. I feel like i should be using the query fields in some manner but I can't put my finger on it. how does filtering a repeating section work using the query fields?https://www.infopathdev.com:443/forums/thread/122975.aspxMon, 11 May 2020 18:12:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122975Froman0https://www.infopathdev.com:443/forums/thread/122975.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122975omg, I can't believe I was missing something so simple. thank you again so much for your help with this.https://www.infopathdev.com:443/forums/thread/122974.aspxMon, 11 May 2020 17:35:05 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122974Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122974.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122974Oh. Just change that calculated value in the column to use the Vendor_DC title without the XPath filter.https://www.infopathdev.com:443/forums/thread/122973.aspxMon, 11 May 2020 17:23:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122973Froman0https://www.infopathdev.com:443/forums/thread/122973.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122973this is close, when an SO is selected, it brings up the vendors, the problem is that if there are no call-ups against that vendor, it shows a space for it, but no the name. I think the problem is that this is a copy of the original section you made that I modified, but it's still getting some of this information from the Callup_DC, but it should be grabbing vendor names from the vendor DC, filtered by the SO selected.https://www.infopathdev.com:443/forums/thread/122972.aspxMon, 11 May 2020 17:14:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122972Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122972.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122972Maybe try this one? I left the preceding sibling rule, but you can remove it if it isn't needed. Sometimes when trying to figure these things out it is easiest to change colors for the section instead of hiding - then you can see which rule is being applied.https://www.infopathdev.com:443/forums/thread/122971.aspxMon, 11 May 2020 17:00:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122971Froman0https://www.infopathdev.com:443/forums/thread/122971.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122971the dropdown control in the form, the SO field from the vendor list will never be blank. I've tried to filter for SO selected on the field tried the same thing in the rules, but all entries from the vendor list always seem to show up regardless of the filter that I'm trying to applyhttps://www.infopathdev.com:443/forums/thread/122970.aspxMon, 11 May 2020 16:46:21 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122970Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122970.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122970When which "SO" is blank? The one in the form (the dropdown control in the form) or the one in the vendors list?https://www.infopathdev.com:443/forums/thread/122969.aspxMon, 11 May 2020 16:36:51 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122969Froman0https://www.infopathdev.com:443/forums/thread/122969.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122969so that didn't work either, I've modified the rules and filters a bunch and still cant seem to get it right. Sorry i'm being confusing, What i'm trying to make happen, is when an SO gets selected, the section in the top right should show the vendors attached to the selected. and to not show anything when the SO is blank. I feel it should be a simple filter, but nothing I try works. I don't think i need the preceding sibling rule because all vendors per SO should show.https://www.infopathdev.com:443/forums/thread/122961.aspxMon, 11 May 2020 15:11:36 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122961Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122961.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122961In the new section, you only want the rows where the SO Number is blank, is that right? I'm sorry - I'm getting confused as to what you want displayed where. At any rate, I made that change in this version. The preceding-sibling rule is so each vendor only shows once? Since I don't know what your list data looks like, I don't know if that is needed in this new section.https://www.infopathdev.com:443/forums/thread/122960.aspxMon, 11 May 2020 14:30:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122960Froman0https://www.infopathdev.com:443/forums/thread/122960.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122960So the original section has two formatting rules on it; the first one is formatting and shows "vendor = preceding sibling::Sharepoint...." (Name: Hide if already displayed) and the other is SO number ≠ SO number (Name: Hide for SO number). I've poked at these rules a bunch, but I cant seem to make it display filtered results based on the SO selected. is this where I would use the query fields in the rules? also, I have no idea what the preceding sibling rules means. what does that do? Thankshttps://www.infopathdev.com:443/forums/thread/122957.aspxFri, 08 May 2020 21:20:15 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122957Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122957.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122957Did you copy the formatting rules from the other table to this one? Right now, there is a formatting rule checking if the SO Numbers match. I think instead you just want to check if the SO Number (in the secondary data source, that the repeating section is bound to) is blank, right? Want to give that a try?https://www.infopathdev.com:443/forums/thread/122956.aspxFri, 08 May 2020 20:49:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122956Froman0https://www.infopathdev.com:443/forums/thread/122956.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122956something didn't work, when an SO is selected, if there are no call-ups, the table is still blank. If I select an SO with call-ups, the vendors get displayed properly. I think it has something to do with the rules on the section, not sure what though.https://www.infopathdev.com:443/forums/thread/122955.aspxFri, 08 May 2020 19:54:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:122955Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/122955.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=122955It looks like the first condition on the new table to only show each vendor once might have been causing the issue - I changed that. The vendor name in this case is the "title" field.