General

Re: Calculated values from Yes/No decisions

KadeshaAsejo — Tue, 16 Nov 2021 05:17:21 GMT

Hello, I am also doing the same project, in which if we choose N/A, the value of that will distribute to other parameters. Is there a way wherein we can covert this excel formula to Infopath? =IFERROR(SUM(J16:J37)/(100-(SUMIF(E16:E37,"N/A",D16:D37))),0) J16:J37 = sum of the points 100 = default E16:E37 = counting of how many "N/A" D16:D37 = the value of the N/A in E16:E37 Hope you can also answer. Thank you very much!

Re: Calculated values from Yes/No decisions

wilkies0106aw — Fri, 12 Apr 2013 11:39:19 GMT

For this kind of thing I immediately turn to Excel. 9 times out of 10 if you can do it in Excel you can do it in InfoPath/SharePoint.

You may also want to look at SharePoint and calculated columns.

So if I've understood you correctly. This is how I've just done it.

For each NA you minus 1 from the total of possible questions.

I'm not sure how practical my solution is - depends on the number of questions?

I set up a form up with 16 Question fields. Each question field as QuestionX . X being a number.

I then set up a Calculations section with the following fields and formulas (you could hide this from public view)

Total Possible Answers Minus NA - TotalPossibleAnswers - NumberOfNA (field names)

Percentage To Use - TotalPossibleAnswersMinusNA (fieldname)

Percentage Calculation - NumberofYes / PercentageToUse * 100 (fieldnames)*100

You mention 6.25. I assume you'll be adding this to an amount somewhere. Not sure what it was connected with or to. Again, hit excel and you'll easily be able to work it out. Yes 16*6.25 = 100 but is it now necessary?

Calculated values from Yes/No decisions

sbonera — Thu, 11 Apr 2013 16:27:49 GMT

Any guidance

Scenario QA Form, have to work out a percentage final score based on the 16 answers responses

16 questions with Yes No and some N/A as answers.

No is fine it does not add to the score. YES and N/A would adjust the score percentage

i.e. 16 yes responses would be 6.25 x 16 questions to give you a score of 100% If one N/A was used the percentages adjust i.e 15 yes and one n/a so percentage would be based on 15 answers.

What I have done so far, Text boxes with rule If question XX is yes then set text box to 6.25% and a final score calculated value adding them all together. It is creating the rules that I need to work out with N/A adjusting.

Any help would be appreciated, or knowing going down the wrong route and there will be a easier, simplier solution.