Creating a Sum using a running total and a conditional formual
Posted on 2013-05-15
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
Running total 2
Running total 1
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.