+ Start a Discussion
james.wallacejames.wallace 

Formulas & Relationships

Hi All,

 

Is it possible for formulas to access other objects specified in the current object as a relationship?  For example, on accounts, I require a field that displays the number of active contracts.  Naturally, I've had a look around the formula editor and none of the options appear to offer this functionality - is it even possible via formulas?

 

Cheers,

 

James

V1nitV1nit

Hi,

 

This a very similar requirement to my implementation. I recently came across this issue and here is what I came up with.

You will need to write a trigger to do this.

 

Refer to the below post

http://boards.developerforce.com/t5/Apex-Code-Development/Alternative-to-Roll-up-summary-field-when-dealing-with-1-object/m-p/415425#M75020