General

Re: Calculate Percentages for total

JonHart — Thu, 20 May 2010 05:39:54 GMT

I must have figured out the [. = "yes"] prob about 1 minute before you posted. have finally come right. Thanks SOOO much for your help@!!!!@@#@#!

Re: Calculate Percentages for total

Jimmy — Wed, 19 May 2010 15:09:24 GMT

Please try this:

100 * count((tq2.1 | tq2.2 | tq2.3)[. = "Yes"]) / count((tq2.1 | tq2.2 | tq2.3)[. != 'N/A'])

Re: Calculate Percentages for total

JonHart — Wed, 19 May 2010 13:20:10 GMT

Ok i am now using the following but getting a returned value of 97.....

100 * count((tq2.1 | tq2.2 | tq2.3)["Yes"]) / count(tq2.1 | tq2.2 | tq2.3) - (count((tq2.1 | tq2.2 | tq2.3)["N/A"]))

I have tried

100 * count((tq2.1 | tq2.2 | tq2.3)["Yes"]) / (count(tq2.1 | tq2.2 | tq2.3) - count((tq2.1 | tq2.2 | tq2.3)["N/A"]))

which gives me "Infinite" as the value...

Both of these formula's dont change when answering the questions...

Re: Calculate Percentages for total

JonHart — Wed, 19 May 2010 05:54:03 GMT

When I use it it joins the [Answer = Yes] the the fields before it.

100 * count((tq2.1 | tq2.2 | tq2.3)[Answer = "Yes"]) / count((tq2.1 | tq2.2 | tq2.3)[Answer != "N/A"])

I get the following error.

"../my:tq2.1/Answer" does not point to a valid location path of a field or group.

Re: Calculate Percentages for total

Jimmy — Tue, 18 May 2010 15:46:15 GMT

Please try this:

100 * count((q2.1 | q2.2 | q2.3)[Answer = "Yes"]) / count((q2.1 | q2.2 | q2.3)[Answer != 'N/A'])

Re: Calculate Percentages for total

JonHart — Tue, 18 May 2010 12:20:49 GMT

I want to get a % total for a series of questions which i have used 3 radio buttons for each question, Yes, No and N/A. I need it to calculate the % on all questions minus the ones marked N/A.

Re: Calculate Percentages for total

Qazi Anis — Tue, 18 May 2010 12:12:52 GMT

what exactlyy do you want

Re: Calculate Percentages for total

JonHart — Tue, 18 May 2010 11:15:09 GMT

Ok i have used the following expression but not liking it...

100 * count(q2.1 + q2.2 + q2.3 [Answer = "Yes"]) / (count(q2.1 + q2.2 + q2.3)) - (count(q2.1 + q2.2 + q2.3 [Answer = N/A]))

Where am I going wrong?

Re: Calculate Percentages for total

Qazi Anis — Tue, 18 May 2010 10:48:03 GMT

you can try

100 * (fiel1, fiel2, ....fieldn) / number of fields

eg: 100 * (field3 + field4 + field5) / 3

Re: Calculate Percentages for total

JonHart — Tue, 18 May 2010 08:07:02 GMT

Perfect thanks!

Just one thing, in your string, you used one "Repeating Field", how would I go about adding multiple fields? I have a field for each question, I.e. Q1.1, Q2.2, Q2.3 etc. What would I use to separate the fields?

Thanks for your assistance with this!

Re: Calculate Percentages for total

Jimmy — Mon, 17 May 2010 14:56:57 GMT

Yes, you would use the formula as the default value for the field where you want to store the value, or you can just use the formula in an expression box if you only want to display the value and not store it in the form's data.

You can use the Select Field... button and its Filter functionality to set up the formula with the correct paths and field names.

Re: Calculate Percentages for total

JonHart — Mon, 17 May 2010 14:43:30 GMT

Defiantly looks right but how would I go about using it? Would I just use it as the default value in the total field? Do i replace "RepeatingField" with the fields that I am using? Please excuse my ignorance but only ever worked with very basic forms. Thanks again!!

Re: Calculate Percentages for total

Jimmy — Mon, 17 May 2010 14:27:49 GMT

Might it be that the formula you want is:

100 * count(RepeatingField[Answer = 'yes']) div (count(RepeatingField) - count(RepeatingField[Answer = 'N/A']))

Calculate Percentages for total

JonHart — Mon, 17 May 2010 14:08:54 GMT

Hi there

Sorry if this has been listed before but I could not find it anywhere. I have a form with 20 questions on it with "Yes" "No" and "N/A" as radio button answers. I have a total field which will give a % score. However, if a person marks a question as N/A the new total question for the % score changes to "Total questions minus number of N/A's selected". It's allot harder to explain typing as I am figuring out now... But hopefully someone understands and can give me an idea on how to go about this. Many many thanks!