---
schema_version: "1"
id: 480e076c0d851c3553d4c8c4ad2a3bfe6dba68085df1f959a975c3a322bd0af1
title: "Use Case 1: Create a State-Specific Primary Address Flag"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_use_case_1.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_use_case_1.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 24628d21069aae9f411e9ab28caec522b78fcc4619b91e6c485e73846ba43d65
description: This use case creates a flag for customers who live in a specific state.
products:
  - Data 360
release: "264"
---
# Use Case 1: Create a State-Specific Primary Address Flag

This use case creates a flag for customers who live in a specific state.

 
| Raw Data | Goal |
| --- | --- |
| The field City State in the format: City, State Abbreviation. For example, San Francisco, CA, or New York, NY. | Create the formula field “Is California” with {TRUE, FALSE} values. Return TRUE if the State Abbreviation is “CA”. |

1. For Field Label, enter Is California.
2. For Formula Return Type, select **Text**.
3. In the syntax editor, enter the formula: IF(EXTRACT(sourceField\['City State'\], ",", 1) == "CA", "TRUE", "FALSE").
    
    Use the == operator to check the equality or difference between values on both sides of the operator.
4. In the test input box, validate the formula using these combinations.
    
    - “City State” with the value of “San Diego, CA” returns “TRUE”.
    - “City State” with the value of “Los Angeles, CA” returns “TRUE”.
    - “City State” with the value of “New York, NY” returns “FALSE”.
5. Click **Save**.
6. Verify that “Is California” is added as a field.

#### See Also

- [_Salesforce Help_: Supported Library Functions](https://help.salesforce.com/s/articleView?id=data.c360_a_supported_library_functions.htm&release=264.0.0&type=5 "In the Data 360 data library, you can choose functions and operators. You can nest functions.")