Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I use my formula field to sort my report highest to lowest?

Status
Not open for further replies.

JeanieP

IS-IT--Management
Sep 13, 2012
3
US
Hello,

I work in the mortgage industry. My problem has to do with sorting my report using a formula field I've created. I have created a report that tracks the number of days "lead time" given to prepare a loan for closing. I use a DateDiff formula to figure the # of days between Docs Requested and Docs Needed by date per loan. That's all working fine. I then count the # of loans and then average the Lead Time (LT) per loan. Report is grouping this information by loan officer. I have another formula field that counts each loan/record where the DateDiff is <=3 days. Then I created another formula that figures out the % of loan volume where the lead time was <=3 days. Detail is surpressed on the report so columns display the outcome as follows: # of loans, Ave. LT, the count of loans <=3 days, and the % of volume that is <=3 days. So, the data displays like this:

LO #Loans Ave. LT #<=3 %<=3

John 35 3.00 25 71.4%
Dennis 22 1.95 21 95.4%
Laura 24 2.08 20 83.3%

I want to sort this report highest to lowest based on my formula field %<=3 (far right column). I want to see the order list: Dennis, Laura, and John last. Since I'm using my own formula, I can't choose it in the normal Crystal Settings for Report Sort, Group Sort, etc. Any ideas for me?

Thanks!
 
Sorting is for detail lines and you are deriving a value from several details.

Maybe you could do it with Top N

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP [yinyang]
 
Thanks Madawc,..but, I did try that. My field doesn't appear in the selection for Top N either. I've resolved the matter by using the summary/count field instead of my % field. It'll have to do.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top