Total with IF/THEN using string-lengths - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Total with IF/THEN using string-lengths

Last post 05-09-2016 12:23 PM by Ramblindewey. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 05-09-2016 09:46 AM

    Total with IF/THEN using string-lengths

    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
  • 05-09-2016 12:23 PM In reply to

    Re: Total with IF/THEN using string-lengths

    Figured out how to correct using a combination of Rules and formula in the Total_Score field. Thank you!
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.