Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is an expression i need to use to find the average " yes" in a yes/no column?
=Count({<COLUMN_NAME_GOES_HERE={'yes'}>}COLUMN_NAME_GOES_HERE)/Count({<COLUMN_NAME_GOES_HERE={'yes','no'}>}COLUMN_NAME_GOES_HERE)
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])
Thanks, But where would i insert the column name?
=Count({<COLUMN_NAME_GOES_HERE={'yes'}>}COLUMN_NAME_GOES_HERE)/Count({<COLUMN_NAME_GOES_HERE={'yes','no'}>}COLUMN_NAME_GOES_HERE)