+ 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
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