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, 201511 yr by Lee Smith
post text changed for readability

Try =

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

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, 201511 yr by Lee Smith
added a link

thanks much, all squared away!