+ Start a Discussion
dkburtdkburt 

Count Number of Open Cases on an Account

Hey Folks,

 

I could use some direction...

 

I have been asked to show in a field the current number of open cases for any account on the page layout and in reports and dashboards.

 

Is this a Visualforce solution, Apex, or combination? I tried with a formula field but I did not have access to the cross object related data.

 

Thanks for the help.

 

Doug

Kirtesh_JainKirtesh_Jain

Hi 

 

Use Roll up summary field on Account to count open cases .

 

 

Thanks

kirtesh 

Mr SlingMr Sling
Hi there - I searched for this exact same question (custom formula field to count number of cases on an Account) and saw your suggestion.  However, when I went to try this it looks like the only Roll-Up Value you can perform for Accounts is with "Opportunities".  (confirmed in "About Roll-Up Summary Fields" help article)
I'll see if I can stash this roll-up summary in another custom object then create a link back into a new Account lookup field... but I doubt that's possible.  Hopefully there's a simple formula that will do the trick.  Thanks!
 
Message Edited by Mr Sling on 09-11-2009 05:44 PM