You need to sign in to do that
Don't have an account?
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
Thanks.
Ron Hess
I don't think formula fields dont support accessing field values thru a lookup relationship