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/125126.aspxThu, 29 Sep 2022 23:44:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125126Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125126.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125126I think the formula just needed some parenthesis. This one seems to work the way you want.https://www.infopathdev.com:443/forums/thread/125125.aspxThu, 29 Sep 2022 23:32:57 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125125hainh19840https://www.infopathdev.com:443/forums/thread/125125.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125125Hi . Can you help me? Phttps://www.infopathdev.com:443/forums/thread/125124.aspxThu, 29 Sep 2022 20:17:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125124Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125124.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125124Ok - I'll get another copy uploaded later today with this fixed.https://www.infopathdev.com:443/forums/thread/125123.aspxThu, 29 Sep 2022 20:05:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125123hainh19840https://www.infopathdev.com:443/forums/thread/125123.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125123HI Ms. Hilary. As you can see in the photo, total hours for 30 row is 184 - If I select Project assigned with LLM ( 3 row - 1Non Bill and 2 Bill) - After that, I click to Project Filter = Total hours should be Sum of 3 Rows = 24 - Then If I click to Bill of Project Filter, Bill Total hours should be 16 hours But in the form it still Sum all BILL hours . It's is not correct.https://www.infopathdev.com:443/forums/thread/125122.aspxThu, 29 Sep 2022 19:27:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125122Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125122.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125122Try the attached copy.https://www.infopathdev.com:443/forums/thread/125120.aspxThu, 29 Sep 2022 19:14:04 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125120hainh19840https://www.infopathdev.com:443/forums/thread/125120.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125120Yes Madamhttps://www.infopathdev.com:443/forums/thread/125119.aspxThu, 29 Sep 2022 18:32:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125119Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125119.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125119So - I just want to make sure I understand. You need help adding the project filter to the two Total fields, outlined in the screenshot?https://www.infopathdev.com:443/forums/thread/125117.aspxThu, 29 Sep 2022 14:54:44 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125117hainh19840https://www.infopathdev.com:443/forums/thread/125117.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125117hi. i attached my real form. example: Project Assigned Column I select A B C with Bill or Non Bill so In project site I will Filter Project with Bill/ Non Bill+ Project Assigned .So the Total Hour will be rẽcalculate alsohttps://www.infopathdev.com:443/forums/thread/125116.aspxThu, 29 Sep 2022 14:34:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125116Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125116.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125116I'm not sure I completely understand the question, but am attaching a sample with a table of distinct types & sites and subtotals for those. Hopefully it helps. :)https://www.infopathdev.com:443/forums/thread/125115.aspxThu, 29 Sep 2022 07:29:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125115hainh19840https://www.infopathdev.com:443/forums/thread/125115.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125115Dear Ms. Hilary, Can you help me with one 1 condition. In your form, I want to make filter of SUM TOTAL by Type and Site. Can we do it? If yes, could you please help me. Thankshttps://www.infopathdev.com:443/forums/thread/125012.aspxFri, 05 Aug 2022 03:15:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125012hainh19840https://www.infopathdev.com:443/forums/thread/125012.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125012Wonderful. Super!!!https://www.infopathdev.com:443/forums/thread/125011.aspxThu, 04 Aug 2022 23:42:37 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125011Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125011.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125011Happy to help - here's my original form with a filtered subtotal.https://www.infopathdev.com:443/forums/thread/125010.aspxThu, 04 Aug 2022 23:36:53 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125010hainh19840https://www.infopathdev.com:443/forums/thread/125010.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125010Dear Ms. Hilary, It's very helpful. You are supper woman. Thank for your support. I have another question. I try to make Sum TOTAL of 1 column. How can I got sum total of this column with Filter option. As I try but it only so the Full total. not total with filter.https://www.infopathdev.com:443/forums/thread/125009.aspxThu, 04 Aug 2022 21:40:34 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125009Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/125009.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125009I've attached a sample form. Right click and save locally, then right click the saved file and select Design. Then you should be able to preview. This is just one option - in your original post, you attached an XML, not your XSN - so if you need help implementing in your XSN feel free to attach.https://www.infopathdev.com:443/forums/thread/125008.aspxThu, 04 Aug 2022 15:37:14 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:125008hainh19840https://www.infopathdev.com:443/forums/thread/125008.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=125008Dear All, Can you please help me to make a filter in Repeating table. Ex: in my form, i have 3 Row in Repeating table with Option Bill and No bill How can I make a filter with option Bill or Non Bill.