Good 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