Combining location() and children.toStringList() in Expression Builder

Hi Community,

We are currently trying to implement a requirement using the Expression Builder and need support from the community experts.

Our view has two viewpoints referencing different dimensions: Viewpoint 1 (Account) and Viewpoint 2 (Profit Center). Both are defined by hierarchical parent-child relationships. In the Profit Center viewpoint, there is a property called [Acc_Parent_Reference], where we store a parent node from the Account viewpoint.

Requirement: We want to use [ACC_Parent_Reference] as the starting point to jump into the Account viewpoint and retrieve all Level Zero Accounts below the Account stored in [Acc_Parent_Reference]. The output should be a comma-separated string of these Accounts.