InfoPath 2010

Re: Calculate check boxes in percentage

Jimmy — Mon, 03 Dec 2012 04:09:25 GMT

You can attach your form by using the Options tab when you hit Reply.

It should be possible to do what you're looking to do, but I'm not entirely clear on what that is.

Re: Calculate check boxes in percentage

Dawg62 — Fri, 30 Nov 2012 16:55:42 GMT

How do you calculate a repeating table to show the percentage as it grows? If there are 7 rows but only 4 are checked yes, how would I calulate that? Is it possible?

I'd send you a copy of the form but don't know how to attach it to this blog.

Re: Calculate check boxes in percentage

Dawg62 — Fri, 30 Nov 2012 16:24:04 GMT

I figured out the problem. I didn't have all the check boxes set to 0 and 1 but to true and false. Now it works. But how to show a % sign witht the value? I like when things finally come together.

Re: Calculate check boxes in percentage

Dawg62 — Fri, 30 Nov 2012 16:16:22 GMT

I changed the text box to fx Calculated Value and when I enter the value it says there is no errors now. This is what is shown in the value box. 1.#QNAN

When I go to preview and check the boxes nothing happens. The same value in the box remains. Getting closer, I think...

Re: Calculate check boxes in percentage

Dawg62 — Fri, 30 Nov 2012 16:06:03 GMT

This is the error I am getting after I select the fields to calculate: The formula contains one or more errors.

"../my:field9../my:field10../my:field11../my:field11../my:field12../my:field13" does not point to a valid location path of a field or group.

This is the calculation I selected and as it was entered in as I select each field name.

(../my:field9../my:field10../my:field11../my:field11../my:field12../my:field13) / 5

Data type is set to decimal. I have tried Text and Whole Number (integer) as Data Type.

I can't get either to work.

I tried to copy the form in and what the page looks like but can't figure out how to do it on this site.Can't find the option to do it...

Re: Calculate check boxes in percentage

Jimmy — Fri, 30 Nov 2012 15:43:39 GMT

The button would be in the formula editor, where you enter the formula:

I misspoke when I said "Select field or group". It should have been "Insert field or group".

Re: Calculate check boxes in percentage

Dawg62 — Fri, 30 Nov 2012 15:37:57 GMT

I have the check boxes in a table format. Not sure how to select field or gropup from filed8 that does the calculations. There is nothing under Text Box Properties that gives me those choices. Is there a site that explains how to do what I need?

Thanks!

Re: Calculate check boxes in percentage

Jimmy — Fri, 30 Nov 2012 15:29:48 GMT

You'll need to actually select the fields using the Select a field or group... button. You can't just type field9.

Re: Calculate check boxes in percentage

Dawg62 — Fri, 30 Nov 2012 15:22:10 GMT

This is the error I am getting: "field9" does not point to a valid location path of a field or group. Field8 holds the calculation. I like to be able to use the Yes, NA valued as 1 and No valued as 0 to get the percentage I need.

Re: Calculate check boxes in percentage

Jimmy — Fri, 30 Nov 2012 15:14:57 GMT

So you have 5 checkboxes in your form that can have the value 1 or 0, and you want to find the percentage that are checked? If so, I imagine this should work:

(field9 + field10 + field11 + field12 + field13) div 5

Re: Calculate check boxes in percentage

Dawg62 — Fri, 30 Nov 2012 14:56:07 GMT

Where would I insert the field names such as field9, field10, field11, field12, and field13? Those are the fields I will want to add and give a percentage from the 5 fields. Do I actuallinsert this in the calculation: "% of this section has been completed. I'm thinking of changing the fields to a drop down box with the values of Yes, No, and N/A. I would want to calcualte the yes and N/A as the percentage and no would like being unchecked and not counted giving me a negative. Example: 4 boxes show Yes or N/A so the percntage would be 80%. I would like to this instead if it can be done.

Thanks!

Re: Calculate check boxes in percentage

Patrick Halstead — Thu, 29 Nov 2012 23:56:19 GMT

Hi Dawg62 and welcome,

I would try something like this: concat(floor(count(*[not(*)][. != ""]) / count(*[not(*)]) * 100), "% of this section has been completed.")

Good luck!

Calculate check boxes in percentage

Dawg62 — Thu, 29 Nov 2012 22:32:15 GMT

I have 5 check boxes (field9-field13) that the cleared field are set to 0 and checked values are set to 1. I want to calcuate all the checked fields divided by 100%. I have tried to enter in the fx calculation in field8 suc as (ROUND((field9)/10,0)+......... ROUND(field10)/10,0))* 2

How would I calculate the percentage in field8? Or is there another way to do this?