https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/107488.aspxWed, 20 Jul 2016 23:51:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107488Jen-hsb0https://www.infopathdev.com:443/forums/thread/107488.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=107488Thank you but I have found the solution right after publishing my post and I couldn't delete it. I didn't need the 1st repeating table nor the optional section. I simplified the form and now the sum are working in the repeating table.https://www.infopathdev.com:443/forums/thread/107484.aspxWed, 20 Jul 2016 17:57:29 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107484Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/107484.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=107484What's the formula for the total field? Click the Edit XPath checkbox and paste in the full formula - as well as the XPath to the Optional section field....https://www.infopathdev.com:443/forums/thread/107391.aspxMon, 18 Jul 2016 01:18:47 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:107391Jen-hsb0https://www.infopathdev.com:443/forums/thread/107391.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=107391Hi All, I designed an Infopath form which has a repeating table followed by another repeating table in an optional section in a repeating section. At the end of each repeating table I have the sum of a column. I also have further down (outside the repeating section) a Total of all the sum fields . In the Total field I have the error "Nan", but it disappear when I open the optional section. What should I do for the Total field to display the result even if the optional section is “closed”. Hope I was clear enough, thank you in advance.