Link to home
Avatar of Maureen Kelly
Maureen Kelly

asked on

Counting specific items in a grouped field

I am working on a report that will show results by account.  I have grouped the report by account.  I am trying to show how many positive and negative results were reported for each account and their percentage rate.  I have tried several  different formulas and methods to get this and keep coming up against a brick wall.  Any suggestions.........
Avatar of Mike McCracken
Mike McCracken

Try this

Create 2 formulas

Name - IsPositive
If {YourField} > 0 then
    1
Else
    0

Name - IsNegative
If {YourField} < 0 then
    1
Else
    0


You can then summarize these as sums and do the calculations

Sum({IsPositive}) / Count({YourField})

Sum({IsNegative}) / Count({YourField})

mlmcc
ASKER CERTIFIED SOLUTION
Avatar of James0628
James0628

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Most of the points should have gone to mlmcc.  I only posted a couple of alterations to his suggestion.  You can use the "Request Attention" link under your post to ask to have the question re-opened, and then split the points between us.

 James