---
schema_version: "1"
id: f1284ccddc46a195f6b1aa02b80c009aab13a9cfdcb5df7f09deb63609fb45d3
title: Calculate Values in a SOQL WHERE Clause (Pilot)
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/release-notes/262-0-0/rn_api_soql_where.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_api_soql_where.htm&release=262.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1b902b90cf36065d15b130d300cf69e18306b7a6ec91def44503392cb9cff7ac
description: Perform arithmetic calculations directly in your SOQL WHERE clauses using the new FORMULA() function. Compare values between fields without requiring formula fields or post-processing logic, and make your queries more efficient and expressive.
products:
  - Cross Cloud
release: "262"
---
# Calculate Values in a SOQL WHERE Clause (Pilot)

Perform arithmetic calculations directly in your SOQL WHERE clauses using the new FORMULA() function. Compare values between fields without requiring formula fields or post-processing logic, and make your queries more efficient and expressive.

**Where:** This change applies to Lightning Experience and Salesforce Classic in all editions. Contact your Account Manager or Customer Success Manager to enroll in the pilot.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-release-notes-salesforce_release_notes-262-0-0-production-enus/e945111b-3e0a-4011-accc-d5949363bfcc/images/icon_note.png)

Note Arithmetic formulas in a SOQL WHERE clause is a pilot service that is subject to the Beta Services Terms at Agreements - Salesforce.com or a written Unified Pilot Agreement if executed by Customer, and applicable terms in the Product Terms Directory. Use of this pilot service is at the Customer's sole discretion.