Sorting Results from a formula

[mudflap]

I have 8 formulas that caclculate each sales reps sales up to the current day.
What I want to do is sort them so they are in order of most money first.
When I try to sort it wants to sort a field name of course.
But these are formulas.
How do you sort all eight formulas at once??

Peter

 

[dgillz]

If these are detail fields, just click on report, sort records. If they are summaries, use the top-N expert.

If the Top-N does not work for your formula fields, please post your formula. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[mudflap]

TopN is always greyed out I can't seem to use it.
I have 8 formulas all adding up each sales persons
sales up to the day.
THe sum formula is adding two other running total results together
{#David}+{#David3}

The running totals are as follows
{Prepress WIP.To (User Defined)} = &quot;David Shackleton&quot; and {Prepress WIP.Invoice Date (Date) (User Defined)} <> date (2002,07,01) to date (2002,07,31)
the other is.
{Prepress WIP.To (User Defined)} = &quot;David Shackleton&quot; and {Prepress WIP.Billed (User Defined)} = $0.00

Any ideas?
First one is David3.
Second David.

So the result is..I have about 8-10 sales peoples numbers all using separate formulas.
I want to sort the results of those.

Thanks
PEter

 

[dgillz]

You cannot use TopN on running totals as you have discovered.

Why can you not just summarize the sales by day and salesperson?

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com