You need to sign in to do that
Don't have an account?
Claire 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
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
Try this and let me know please :)
/00O58000002crV0?pv0={!Account.Id}&pv1={!Account.Id}
All Answers
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.
Try this and let me know please :)
/00O58000002crV0?pv0={!Account.Id}&pv1={!Account.Id}