Re: Calculating fields to add up to a set percentage; how do you add the % symbol

Patrick Halstead — Mon, 24 Nov 2014 12:04:22 GMT

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!

Calculating fields to add up to a set percentage; how do you add the % symbol

shamisty — Tue, 18 Nov 2014 19:03:48 GMT

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!

Newbie Questions

Re: Calculating fields to add up to a set percentage; how do you add the % symbol

Calculating fields to add up to a set percentage; how do you add the % symbol