function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Report: CountIF equivalent for a range with a column

Hey all, 


We're working with SF Reports, and see that we should be able to count a range within a column. Our column is in percentages, and we want to know how many records fall within several different percentage ranges, for instance:


Within this object, how many records are under 15%?  How many are between 15% and 50%? Above 50%? 


Using the logic therein, it seems that we should be able to do this; but Group By or Count don't seem to go this far. Any suggestions, or has anyone done this?




Jake GmerekJake Gmerek



I would create a custom field for each percentage range on  your object that is a formula and checks to see if the record fall in the range sort of like:


if (percentage < 15, 1, 0)


Then all you have to do in the report is SUM that field and you have the total number of records that meet your criteria.