I am having account hierarchy, i.e. there is one parent account and multiple child account. They are connected through Hierarchy relationship field which is lookup on the child account, i.e. on the child account there is lookup field for the account.
Example: ABC corp(parent account) & ABC Corp-US(child account)
Hierarchy is like:
-ABC Corp -ABC Corp-US
There is field called Amount on account object which is populated for all the child and parent records. I want the sum of that field and display the result on the Parent account. How can we achieve this?
I tried but since it is hierarchy relationship how to add up Amount field.
Since it is single object 'Account' and it is having same field Amount for both Parent and Child.