InfoPath Dev

Ok, I know how to add the fields together to get a total, I also know how to get it to be a percentage, my question is............... How can I make my "total" field set to 100%, or as the previous fields are being entered, that the "total" field is being calculated, but it cannot exceed 100%??? Also, how in the heck do I get the % symbol to show in my fields? Please help!

Hi Misty,

Thanks for posting. You can use some complex XPaths to do this... here are some examples:

• Repeating sections (example)

  • Total Percent Completed: 
    (TotalAnsweredTest / TotalQuestionsTest) * 100

  • TotalAnsweredTest: sum(AnsweredYN)

  • TotalQuestionsTest: count(AnsweredYN)

• Independent fields (example 2)

  • Total:
    count(field1 | field2 | field3 | field4 | field5 | field6 | field7 | field8 | field9 | field10)

  • Percent:
    100 - (100 * count(field1[. = ""] | field2[. = ""] | field3[. = ""] | field4[. = ""] | field5[. = ""] | field6[. = ""] | field7[. = ""] | field8[. = ""] | field9[. = ""] | field10[. = ""])) / Total

• More advanced – use calculated values (no additional fields req’d)

  • All fields: count((//*[not(*)] | //@*)[not(name() = "xml:lang")])

  • Filled in: count((//*[not(*)] | //@*)[not(name() = "xml:lang")][. != ''])

To get the % symbol to show up, don't worry about putting it in the field. Just type it in after the field. 

Please let us know if you have any other questions!

:)