Average

[chiso_chiso]

               X          Y          Z

John     Yes      No          Yes

Mary      -          No          Yes

Harry    Yes     Yes          Yes

Mike     No         No         No

Kindly assist, from the above scenario;

Calculating the average of Yes' and No's of X,Y and Z

[anbu1984]

How do you calculate avg ?

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[chiso_chiso]

Thanks Gysbert