You need to sign in to do that
Don't have an account?
Formula field for opportunity
Hi All,
I have a requirement where I need to create a formula field on opportunity object which reefrs to a custom object.
Let me explain it in detail. I have a custom object called Booking quota which has booking amount for different users/Opportunity owners. It is like below one.Let say there are three opportunity user A, B, C.
My object Booking Quota has details like this:
Booking Quota
(Opportunity Owner) Amount
A $100000
B $120000
C $180000
Now I have these different opportunity owners on opportunity page. I want to create a formula on opportunity object field let say Booking Amount which populates $100000 if opportunity owner is A and $120000 in case of B.
Please tell me how this can be achieved.
Thanks
~Alok
Hi,
Try this:
Let me know if this is helpful.
Steve
Thanks for your reply.
But I didnot want to hard code it. I want that amount is entered on Bkkoing_Quota object so that if a user wants to change he can change the amount and it gets populated according to the opportunity owner.