If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Running Count off of a Rank

Started by jsibley, Yesterday at 03:57:35 PM

Previous topic - Next topic

jsibley

I have workflow set up for approvals.  One person can have multiple approvals span over different days.  I tried doing a running count like this running-count([Initiated Date] for [Employee Number]).  The result gives me a running count of all of the employee number ignoring the Initiated Date.

I switched it rank seems to count the numbers well.  The challenge is I want to have a running count based off a rank like this:
1   1
1   2
2   1
2   2
2   3

I switched the Auto group & summarize button on and off and it didn't help.  Any ideas?

jsibley

I figured it out.
running-count([Initiated Date] for [Employee Number], [Rank])