function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
akirapltakiraplt 

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?

 

Thanks!

--Dave

Jake GmerekJake Gmerek

Hello,

 

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.