Custom calc for returning a percentage for number of times 'Yes' is returned in other fields.

Question

Hello,I have a series of fields that require a yes, no, n/a answer from a drop down. Then I need to auto calculate the # of times 'Yes' is selected divided by the number of Yes's and No's (but excludes adding the na's into the denominator). Numerator=Countif("yes")/Denominator=Countif("yes" or "no").Thanks

try67 · Accepted Answer

OK, then you can use this code as the custom calculation script of the field where you want the result to appear (PC MCKTOTAL):

var totalYes = 0;
var total = 0;
for (var i=1; i<=5; i++) {
    var f = this.getField("PC MCKRow"+i);
    if (f.valueAsString=="Yes") {
        totalYes++;
        total++;
    } else if (f.valueAsString=="No") {
        total++;
    }
}
if (total==0) event.value = "";
else event.value = totalYes / total;

try67 · Answer

What are the names of the fields involved?

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.