Turning symbols into a percentage

Laura_Murphy

I have a parent row where I would like to show the % of ticked answers for all the children rows . I can see that the tick is formatted as 'YES' but i can not work out the formula to change the yes into a number to get the %?

Percentages.PNG

Nasir@EBC

Hi

You may use the following formula which will show you the percentage; however, you could use YES or Y as an alternative to the tick symbols. This is because if we change the column type to symbols then we cannot place a formula to display % values in it.

=IF(COUNTIF(CHILDREN(), "YES") > 0, COUNTIF(CHILDREN(), "YES") / 10 * 100, 0)

Also, you need to replace the number 10 (in the above formula) with the number of child rows of the given parent row to obtain the right percentage.

Hope this helps.

Best

Nasir (Zealvert)

Nasir@EBC

Hi

You may use the following formula which will show you the percentage; however, you could use YES or Y as an alternative to the tick symbols. This is because if we change the column type to symbols then we cannot place a formula to display % values in it.

=IF(COUNTIF(CHILDREN(), "YES") > 0, COUNTIF(CHILDREN(), "YES") / 10 * 100, 0)

Also, you need to replace the number 10 (in the above formula) with the number of child rows of the given parent row to obtain the right percentage.

Hope this helps.

Best

Nasir (Zealvert)

Laura_Murphy

Thanks so much this has worked perfectly