Any way I can sort on a running total? 1

[sue1127]

I know that Crystal doesn't allow sorting on running totals because the totals are calculated after the sorting. Is there any way I can get around this? I have a formula that obtains the variance between 2 running totals, and I would like to list them highest to lowest.

Thanks,

Sue

 

[chelseatech]

Do you need running totals. Can you use a Summary field on a conditional formula, and then use TopN on that.

Or do a variance formula to do the intial calculation on the raw data, a sumamry of your variance, and then TopN/Sort that summary Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[sue1127]

Thanks for the suggestions. I'll give them a try.

Sue

 

[sue1127]

I've tried summarizing, but Crystal won't allow me to do a top N on the variance, just on individual summarized fields
that I use to get the variance(annual budget and ytd spent). I can't do a summary or Top N on the subtraction.

I might be missing something, but I'm kind of stumped right now.

Sue

 

[IdoMillet]

Create a detail-level formula that computes the variance (no summaries involved).

Now sum that formula at any level you wish and apply a TopN / Sort Group operation to those summaries.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[sue1127]

Thanks very much. That did the trick.

Sue