Ordering on a Formula Field - URGENT HELP NEEDED 1

[Transcend]

I have a formula field GrandTotal, which is the addition of two other formulas, PriceTotal and TotalWeighted

TotalWeighted looks something like:
tonumber(Sum ({@Weighted}, {ado.Form2124ID})/ Count ({@ReviewPanelName}, {ado.AssessmentID}))

And PriceTotal looks like:
tonumber({@PriceRawScore}*({@PriceWeighting}/100))

As you can see each of these are built up from previous formulas.

Is there any way that I can Order my report by this final Formula of GrandTotal, which has been built up by other formulas??

 

[AWithers]

Shouldn't be a problem, go menu item 'report' and then 'sort records' and then select your formula field and 'add'.

It certainly works for a number of my reports (i'm using CR 8.5)

Andy

 

[dgillz]

Grand total seems to be a misnomer. There is only one grand total and no order by should be necessary, so I am assuming you are talking about a group total here.

Are you saying you want to sort by the value of this group total field, rather than by the group itself? If so you need to use the TopN/Sort Group expert to do this.

Click on Report, TopN/Sort Group Expert, and pick your summary field. Let me knoe if you have any questions.
Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[debunky]

I have a similar problem......but my formula doesn't show up for me to select it. Does anyone know why?????

 

[IdoMillet]

Crystal can't use an aggregate formula (or a formula based on an aggregate functions) to sort a report.

As indicated above by dgillz, you need to rely on the TopN / Sort Group expert instead.

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

http://www.MilletSoftware.com

 

[Transcend]

Hi there,
thankyou for your replies. Yes my apologies, it's a group total. There are 3 groups. I am already using the Top N Sort to sort on a summary field in the group, but it doesn't always necessarily order the report by the group total.

Clare