Change in Report Summary Function
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.
Best Answer
-
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
Answers
-
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
-
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
-
@Genevieve P. is there any update on this issue?
-
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
Help Article Resources
Categories
Check out the Formula Handbook template!