+ Start a Discussion
Juan VenturaJuan Ventura 

Need a formula to add the first 3 sales of an account

Hi all!

I'm a beeginner and I need a formula field to add the first 3 sales recorded of an account.

I don't have already the sales field in my account fields.

Hope you can help me
ALBERTO GOMEZ 4ALBERTO GOMEZ 4
Hi, I think it could be solved assinging Opportunities to an Account, you can get a total of your Opportunities amounts.
bk sbk s
Hi,
  You can query the Opportunity , order them by status (closed Won) and then by the date(desc) -> Now show the first three records 
SuAkSuAk
Hi - If the sales is a child record for the Parent Account. Then we can use the roll up summary field to get the sum of sales recorded for an account.

Hope this helps.