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/121572.aspxSun, 22 Sep 2019 04:56:09 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121572lionheart23080https://www.infopathdev.com:443/forums/thread/121572.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121572Hi Hilary, Sorry for not coming back to you earlier. Yes this is exactly what i need . its the calculated values that made it work. Great work & Thank you so much for you kind help. Have a wonderful day.https://www.infopathdev.com:443/forums/thread/121554.aspxThu, 19 Sep 2019 15:37:58 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121554Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121554.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121554I made a guess on which dropdowns were involved and added calculated values that I think will work for these. Save the attached file locally. Right click, select design. Then preview to see if this works the way you need - if not, let me know and we'll try again. :)https://www.infopathdev.com:443/forums/thread/121553.aspxThu, 19 Sep 2019 15:23:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121553Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121553.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121553Oh, it is a list form, which slightly changes the answer, since you aren't dealing with repeating data. Is it the Credential Status that will have the options of "Approved" etc?https://www.infopathdev.com:443/forums/thread/121551.aspxThu, 19 Sep 2019 05:25:27 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121551lionheart23080https://www.infopathdev.com:443/forums/thread/121551.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121551Hi Hilary, I see your name almost all over InfopathDev.com :) that is great. Thank you for your kind response. Frankly i couldn't do it myself, so i am attaching the form here maybe you could take a look please. Appreciate your kind help. regardshttps://www.infopathdev.com:443/forums/thread/121550.aspxWed, 18 Sep 2019 15:25:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121550Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/121550.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121550You'll use the sum function. When you select the value field (which is repeating) you should be able to click the Filter data button and add a filter - where you'd pick the dropdown field, then is equal to, then type in the value (like Approved or Rejected or what-have-you). That gets you the correct sum! Feel free to attach your form under the options tab to a reply and I can help you with this.https://www.infopathdev.com:443/forums/thread/121547.aspxWed, 18 Sep 2019 07:54:42 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:121547lionheart23080https://www.infopathdev.com:443/forums/thread/121547.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=121547HI, I have a form made with Infopath 2013. The form has 3 drop down list (values of these drop list are : Approved, Rejected, Pending Then down the form below, I have 3 fields (Sum of Approved), Sum of Rejected, Sum of Pending). If drop down list 1 has (Approved) and drop down list 2 has (Rejected) and drop down list 3 has (Approved). I want to have the sum of these drop down list in the appropriate field of SUM So for example the field : Sum of Approved should have the value of (2) and the field of Sum of Rejected should have (1) and Sum of Rejected (0). Am not sure if the SUM or COUNT should be used here. Appreciate your help.