Help with Range Formula

[samcneal]

I am trying to write a formula to compute calculations based on a range of FICO scores but I'm not sure how.
I.E. Credit Scores
720+ Calculate units, Volume, Calculcate weighted averages, etc.

I've already computed the calculations but I need to redo them based on a credit score ranges. Any ideas?

 

[synapsevampire]

It's unclear what the intent is, but it's best to supply technical information:

Crystal version
Database/connectivity used
Example data
Expected output

If you're trying to provide calculations based on some ranges of values, you can create a formula with an IF statement, such as:

If {table.FICO} < 700 then
<insert calculation>
else
If {table.FICO} in 700 to 850 then
<insert calculation>
else
If {table.FICO} in 851 to 900 then
<insert calculation>
else
If {table.FICO} > 900 then
<insert calculation>

If this doesn't help, please provide more information.

-k

 

[samcneal]

Thank you that helped.

I created the formulas and I got the desired results.
Ideally, the following is what I need more:

Credit Score Units Volume
720+ 4 $425,000
719 - 700 6 $600,000

I got the Units and Volume to work based on the credit score range but how do I display the range criteria in the report?

 

[samcneal]

I'm guessing that I would have to create a group formula to display the credit score range but I'm not sure how.