Link to home
Create AccountLog in
Avatar of josslmpd
josslmpdFlag for United States of America

asked on

Creating a Sum using a running total and a conditional formual

I need to clasify if a case has more than one request associated with it.  I was able to accomplish this through groups and a running total.  The data looks like this

Group a
Request 1
Request 2
   Running total 2

Group B
Request 1
    Running total 1

Group C
Request 1
request 2
Request 3
   Running total 3

Now I want to determine how many cases (groups) have more than one associated request.  I created an if/ then formula based on the running total, but I can't sum this as already includes summary data.  From looking at other posts, I think that I need a variable, but I am unsure how to do this and what forumla(s) I might need.  

I just want a total sum of all cases (groups) that have more than 1 request associated with it.  Any help will be greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of josslmpd

ASKER

Thank you, that worked perfectly.  Do you know of any resources, on this website or others, that explains variables and how to use them?
Avatar of Mike McCracken
Mike McCracken

I don't have any links readily available here.  I will try to check from home

mlmcc