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!
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!