Change in Report Summary Function

NikiG

Was there a recent change to the summaries function in a report. In my example below the summary count would only calculate if the box was checked.

For example the adj approved count for this section would be 1 and the count for adj rejected would be 4, instead of it counting the total rows for both. Is there a way to change this back. I was reading about the countif function but not sure how to apply to all of the sheets that we pull from.

Genevieve P.

Hi @NikiG

It's been confirmed that the COUNT behaviour on a checkbox column in a Report is currently functioning as it should: it will count all rows that contain a checkbox (unchecked or checked) as a number. You will need to Group by if it's checked or not to see the separate numbers, or use a Filter in your Report. An alternative would be to use a COUNTIF cross sheet formula to gather your numbers instead.

I've submitted an Enhancement Request on your behalf so a COUNTIF statement for checkbox columns in Reports can be considered for future developments.

Cheers,

Genevieve

Genevieve P.

Hi @NikiG

What you're seeing now is the expected behaviour for a COUNT on Symbol or Checkbox columns in Reports.

If you need to see individual Counts (un-checked versus checked) then you can set up a second Grouping in order to split out the two values:

This was a fix our Product team recently released as previously the grouping of un-checked values would have said 0, which is incorrect.

Cheers,

Genevieve

Genevieve P.

Hi @NikiG

Just a quick note to let you know that I've let the Product team know about your use-case and how this update has affected your current set-up.

They're currently investigating what the expected behaviour for a Report should be when it comes to checkbox columns and summarizing. I'll post again once there's another update on this, although I don't have an ETA for when this may be.

Thanks,

Genevieve

NikiG

@Genevieve P. is there any update on this issue?

Genevieve P.

Hi @NikiG

It's been confirmed that the COUNT behaviour on a checkbox column in a Report is currently functioning as it should: it will count all rows that contain a checkbox (unchecked or checked) as a number. You will need to Group by if it's checked or not to see the separate numbers, or use a Filter in your Report. An alternative would be to use a COUNTIF cross sheet formula to gather your numbers instead.

I've submitted an Enhancement Request on your behalf so a COUNTIF statement for checkbox columns in Reports can be considered for future developments.

Cheers,

Genevieve

Brad Powers

While I understand why the change was made to how the COUNT summary behavior works on checkboxes, it seems like we should have the option to use a SUM function rather than a COUNT to calculate the number of "true" checked values (1) rather than counting all rows. This would be less effort than developing a new COUNTIF function and would make reporting much more efficient.

I currently have to either change my checkbox columns to a text column and use 1 and 0 values, which doesn't make sense to my end users, or I have to add a helper column that converts checkboxes to a text column across all sheets. Many of my sheets are too close to the cell limit to allow for the addition of another helper column.