Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
GW2
Contributor
Contributor

Hi, i am a newbie - How to calculate average " yes" in a yes/no column?

What is an expression i need to use to find the average " yes" in a yes/no column?

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

=Count({<COLUMN_NAME_GOES_HERE={'yes'}>}COLUMN_NAME_GOES_HERE)/Count({<COLUMN_NAME_GOES_HERE={'yes','no'}>}COLUMN_NAME_GOES_HERE)

View solution in original post

3 Replies
jwjackso
Specialist III
Specialist III

If there values of [yes/no] are only 'yes' and 'no'

=Count({<[yes/no]={'yes'}>}[yes/no])/Count({<[yes/no]={'yes','no'}>}[yes/no])

or 

=Count({<[yes/no]={'yes'}>}[yes/no])/Count([yes/no])

GW2
Contributor
Contributor
Author

Thanks,  But where would i insert the column name?

jwjackso
Specialist III
Specialist III

=Count({<COLUMN_NAME_GOES_HERE={'yes'}>}COLUMN_NAME_GOES_HERE)/Count({<COLUMN_NAME_GOES_HERE={'yes','no'}>}COLUMN_NAME_GOES_HERE)