Calculated Field (if 'state' = x, calculate 'region' = west/east

[jsissov]

i have several records in a db that contain a state value (i.e. ca, va, hi, co...) i want to create a calculation field that populates the value 'east' and 'west' depending on the values in the state field... ca, hi, co, or, wa, return 'west' ga, va, md, dc return 'east'

Edited January 8, 2015 by Lee Smith
post text changed for readability

[comment]

Try =

Case (
not IsEmpty ( FilterValues ( State ; "HI¶CO¶OR¶WA" ) ) ; "West" ;
not IsEmpty ( FilterValues ( State ; "GA¶VA¶MD¶DC" ) ) ; "East"
)

[Lee Smith]

Please do not paste your questions from anything but a text editor. Something like MS Word will make the text unreadable.

 

Also, please update your profile to reflect your Current Info such as FileMaker Version, Operating System, and Platform.

 

Here is a quick link for your connivence MY PROFILE

Edited January 8, 2015 by Lee Smith
added a link

[jsissov]

thanks much, all squared away!