Calculating % of Yeses in child rows from Yes/No Column

MarkCep

I am looking to get a percent of "yes" in a column named "Yes/No" in the parent row. Example, I have a parent row with 5 child rows - 4 of the child rows have "yes" one has "No" I am looking to show the % of "Yes" in this case the result should be 80% with Yes.

Thanks

Samuel Mueller

@MarkCep Try this

=COUNTIF(CHILDREN([yes/no]@row), "Yes") / COUNT(CHILDREN([yes/no]@row))

Might need to wrap iferror around it

=IFERROR(COUNTIF(CHILDREN([yes/no]@row), "Yes") / COUNT(CHILDREN([yes/no]@row)), "")

Samuel Mueller

@MarkCep Try this

=COUNTIF(CHILDREN([yes/no]@row), "Yes") / COUNT(CHILDREN([yes/no]@row))

Might need to wrap iferror around it

=IFERROR(COUNTIF(CHILDREN([yes/no]@row), "Yes") / COUNT(CHILDREN([yes/no]@row)), "")

MarkCep

Fantastic, this worked perfectly.

Thank you so much