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
Sai.MaharajpetSai.Maharajpet 

how can i calculate average from today to post one year please suggest me any formula thanks

how can i calculate average from today to post one year please suggest me any formula thanks
ShirishaShirisha (Salesforce Developers) 
Hi Sai,

Greetings!

For the number of  Days Remaining  the formula would be:

Datatype = Formula 
Result = Number 
Formula =  TheDateField__c - TODAY() 

Then you can use AVG function to average the result.

Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future.

Warm Regards,
Shirisha Pathuri