+ Start a Discussion
Winsoft Tech.Winsoft Tech. 

Problem facing while creating some formula.

There are three custom objects namely , Security , product and Benchmark.
There is relationship between  Security  and Benchmark  and  between product and Benchmark.
In benchmark object, I want to calculate some value which is depends on some filelds of Security object and product object. I am facing problem for accessing fileds from Security object and product object in Benchark while creating formula in Benchmark.
For example:-
I want  to calculate Quantity like below.
Quantity= (Model AUM * Holding) /Market Price.
Where ,
Model AUM is from product  object.
Market Price is from Security object.
Holding is from Benchmark object.
Quantity is formula field in Benchmark.
In Benchmark object, i created new formula field Quantity,
selected filed type as Benchmark. But in insert filed drop down list the fileds Model AUM and Market Price fields are noe accessible to me. Only custom objects (Product and security) are availabel to me.
So is any solution is there to acess Model AUM and Market Price  from Product and security objects respectively to calulate Quantity.  Or can we acess these fileds through there respective objects like Product.Model_AUM
Ron HessRon Hess
I don't think formula fields dont support accessing field values thru a lookup relationship