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/106498.aspxMon, 09 May 2016 19:23:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106498Ramblindewey0https://www.infopathdev.com:443/forums/thread/106498.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=106498Figured out how to correct using a combination of Rules and formula in the Total_Score field. Thank you!https://www.infopathdev.com:443/forums/thread/106496.aspxMon, 09 May 2016 16:46:48 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:106496Ramblindewey0https://www.infopathdev.com:443/forums/thread/106496.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=106496Good morning - I'm trying to get the various status' to add up to a total number (Status_1:Status_17). Then, if Status_2, Status_4, Status_6, or Status_7 = 0, the entire Total_Score should = 0. Here is the formula in InfoPath that I've created so far for the Total_Score field... When I publish the form to SharePoint, it IS working for Status_2 and Status_7 - but NOT working for Status_4 or Status_6. I've attached a screenshot, as well as pasted the formula below. What am I missing? Any help would be GREATLY appreciated! My background is Human Resources - please be gentle! ((Status_1 + Status_2 + Status_3 + Status_4 + Status_5 + Status_6 + Status_7 + Status_8 + Status_9 + Status_10 + Status_11 + Status_12 + Status_13 + Status_14 + Status_15 + Status_16 + Status_17) + (((5 - string-length(Status_2 > 1)) * 1 + (5 - string-length(Status_2 1)) * 1 + (5 - string-length(Status_4 1)) * 1 + (5 - string-length(Status_6 1)) * 1 + (5 - string-length(Status_7