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
Amanda HollowellAmanda Hollowell 

Round() function available is SOQL?

Is the ROUND() function available in SOQL?

I am using a SOQL query to average all the records in a formula field (This formula field calculates the time between two date fields)
Currently when I calculate the average for the formula field it includes two decimal places. I would prefer the result only include whole numbers.

Thanks in advance for your help!
Best Answer chosen by Amanda Hollowell
James LoghryJames Loghry
There is no ROUND function in SOQL, but there are ROUND, CEIL (Ceiling) and FLOOR functions in both Apex (using the Math class) and Visualforce functions.

All Answers

James LoghryJames Loghry
There is no ROUND function in SOQL, but there are ROUND, CEIL (Ceiling) and FLOOR functions in both Apex (using the Math class) and Visualforce functions.
This was selected as the best answer
Amit Chaudhary 8Amit Chaudhary 8
Aggregate Functions
Aggregate functions includeAVG(), COUNT(), MIN(), MAX(), SUM(), and more.
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_agg_functions.htm

Date Functions
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_date_functions.htm

Please let us know if this will help you