Returning different value

[rbescos]

My table has a field called "Reside_Type" which will currently return one of three values. I'm trying to get the report to return one of three numbers instead.

"Primary" should return "1"
"Secondary" should return "2"
"Investment" should return "3"

Thank you in advance

 

[kray4660]

Formula:

if {Reside_Type} = "Primary" then "1"
else
if {Reside_Type} = "Secondary" then "2"
else
"3"

This should work, unless there are other data values you did not mention.

 

[rbescos]

Thank you kray4660.. It works perfect!!