Hello,

the result for a report I'm writing looks like:
Region                                                              Data
Interstate -                                                       xxx
NSW - Other - give details in notes -                xxx
Overseas -                                                        xxx
Sydney - Inner                                                  xxx
Unknown - Information not collected                xxx

I would like to modify the region data to show as just NSW and Unknown, and the rest leave as they are.

I'm using a formula:

if {table.field} = "UNKNOWN - information not collected"
then REPLACE({table.field}, "UNKNOWN - information not collected", "UNKNOWN")
else

if {table.field} = "NSW - Other - give details in notes" then
REPLACE({table.field}, "NSW - Other - give details in notes", "NSW")

How can I finish this formula toleave the other regions untouched? At the moment it only displays the two modified regions.

thanks

beautiful. thanks!