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
TilluTillu 

How to calculate average on Roll up field.

I have a custo object  Business. and i have a field  'Amount' on this object. On Account i want to display average of this  'Amount' field. I have created a Roll Up on Account but it was giving only Count , SUM,MIN,MAX. Then How to calculate Average? for this
Ashish_SFDCAshish_SFDC

Hi Anvesh, 

 

Currently this feature is not available, please vote for the idea below, 

 

https://success.salesforce.com/ideaView?id=08730000000igfrAAA

 

Regards,

Ashish

 

 

 
Ashish_SFDCAshish_SFDC

Hi Anvesh, 

 

 

You can also create an Apex Trigger to update the field. See the sample code below, 

 

http://www.anthonyvictorio.com/salesforce/roll-up-summary-trigger/

 

http://blog.elieperez.net/salesforce-lookup-roll-up-summary/

 

http://pranavmarathe.blogspot.in/2012/02/salesforce-simple-roll-up-summary-using.html

 

 

Regards,

Ashish
Rahul_sgRahul_sg
How about this:
1) Create a Rollup Summary field: Sum
2) Create another Rollup Summary: Count
3) Create a formula field: Sum/count.
Display Avg on the page layout
Nasser Gazi 9Nasser Gazi 9
That would be too easy. The problem is, SF doesn't allow you to use Rollup Summary fields in formulas
Eugene Murtagh 8Eugene Murtagh 8
I was able to use a roll up summary value in a formula field no probs. Thanks Rahul_sg
jio limitedjio limited
We can achievrle this using SUM/COUNT function of rollup summary