Set expression with multiple values

[stabben23]

I have problem to get sales when i have multiple %childs, what i want is when i select %Head i want to get all sales values from %Child. This works when i have a 1 to 1 relation between %Head and %child not when %childs are many.

This is about Items and need to know the sales from the Headitem and the childitems that belongs to the Headitem in the same Expression.

My expression: sum ({$<%Head =  {"$(=%child)"}>}Sales)

[sushil353]

can u post the sample data

[stabben23]

Sushil, no Ii cant.

[lironbaram · Accepted solution]

hi

may be you can try something like

sum({<%Heads={"$(=concat(%Child,',')"}>}Sales)

[stabben23]

Thanks liron, smal correction with no of Brackets and reduce of " then it works perfect!

sum({$<%Head={$(=concat(%child,','))}>}Sales)