+ Start a Discussion
Claire NicolayClaire Nicolay 

Show parent & child accounts opportunities on parent account using formula field?

I have created a report with the following conditions to see all opportunities for parent & child when accessing account and clicking link in formula field:
parent accound id equals ""
OR account id equals ""

and the following formula field:
HYPERLINK ('/00O58000002crV0?pv0=' + Id , 'Open Report')

When I go to an account, and check the link, only the first condition shows the corresponding id, while second condition remains empty...
Can anybody help by amending existing formula or suggest another/better way of accessing all opportunities linked to account & children from the parent account on account tab? Many thanks
Best Answer chosen by Claire Nicolay
Mina Michel GorgyMina Michel Gorgy
Hi Claire,

Try this and let me know please :)

/00O58000002crV0?pv0={!Account.Id}&pv1={!Account.Id}

All Answers

Mina Michel GorgyMina Michel Gorgy
Hi Claire,

Hope you're doing great.

You are almost there... It should be as follows:

HYPERLINK('/00O58000002crV0?pv0=' + Id + '&pv1='+Id, 'Open Report')


Where in your report, you should have 2 parameters. The first should be "Account ID" and the second "Parent Account ID"... Try it now and it will work :)

Let me know then.
Claire NicolayClaire Nicolay
it works! many thanks
Mina Michel GorgyMina Michel Gorgy
Great. Let me know if you need any more help.
Claire NicolayClaire Nicolay
Then one more question if I May. Would it be possible to open the same report in the same way adding a custom link on the account page? If so, what would the formula look like? Many thanks
Mina Michel GorgyMina Michel Gorgy
Hi Claire,

Try this and let me know please :)

/00O58000002crV0?pv0={!Account.Id}&pv1={!Account.Id}
This was selected as the best answer
Claire NicolayClaire Nicolay
works perfectly. Thanks a lot, much appreciated