function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Deepak Singh 116Deepak Singh 116 

can we use formula field in SOQL query?If yes, please give a example.

can we use formula field in SOQL query?If yes, please give a example. 
Thanks.
Chandra@AtlantaChandra@Atlanta
Deepak,

Account object

Column1 :  hoursperday__c
Columns2: Noofdays__c
Column3: Totalhours__c  ( formula: column1 * column2 )
 
SOQL

select hoursperday__c, Noofdays__c, Totalhours__c
from account
where
 Totalhours__c > 0

"Appreciate Your Feedback"
Raj VakatiRaj Vakati
Yes .. you can use same like standard SOQL . 

Select <API_NAME_OF_formula> from <Object_Name>