InfoPath Dev

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?

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!

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!

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

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.

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

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!

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".

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...

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...

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.

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.

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.