Crystal 10 Formula help needed

[HookEmHorns]

My client has asked me to edit a report by adding in:

“200% - 250%” and “250% and over”. I am uncertain how to edit this. Any suggestions?

Current Formula called in the report:

If RTRIM({ado.Income}) < '101' then '1. 0% - 100% of Poverty' else
    if RTRIM({ado.Income}) > '101' and 
        RTRIM({ado.Income}) <'151' then '2. 101% - 150% of Poverty' else
    if RTRIM({ado.Income}) > '150' and 
        RTRIM({ado.Income}) <'201' then '3. 151% - 200% of Poverty' else
    if RTRIM({ado.Income}) > '200' AND RTRIM({ado.Income}) <> 'Unknown' then '4. Over 200% of Poverty' else
    '5. Unknown'

 

[lbass]

Can't you just carry out the current logic?

If RTRIM({ado.Income}) < '101' then
'1. 0% - 100% of Poverty' else
if RTRIM({ado.Income}) > '100' and
RTRIM({ado.Income}) <'151' then
'2. 101% - 150% of Poverty' else
if RTRIM({ado.Income}) > '150' and
RTRIM({ado.Income}) <'201' then
'3. 151% - 200% of Poverty' else
if RTRIM({ado.Income}) > '200' AND
RTRIM({ado.Income}) <'251' then
'4. 201% - 250% of Poverty' else
if RTRIM({ado.Income}) > '250' AND
RTRIM({ado.Income}) <> 'Unknown' then
'5. Over 250% of Poverty' else
'6. Unknown'

-LB