topic How to use straight table expression in aggr expression ? in App Development

How to use straight table expression in aggr expression ?

seWork — Tue, 13 Jul 2021 09:12:00 GMT

Hi all,

I have a straight table that contains a Group dimension and the following expression

pick(match('A','B','C','D'),

sum(aggr(sum(XYZ),Item,Group))*vA ,

sum(aggr(sum(XYZ),Item,Group))*vB ,

sum(aggr(sum(XYZ),Item,Group))*vC,

sum(aggr(sum(XYZ),Item,Group))*vD)

This expression returns the expect result

I'm trying to have another expression that will look like

sum(aggr(Vol*

pick(match('A','B','C','D'),

sum(aggr(sum(XYZ),Item,Group))*vA ,

sum(aggr(sum(XYZ),Item,Group))*vB ,

sum(aggr(sum(XYZ),Item,Group))*vC,

sum(aggr(sum(XYZ),Item,Group))*vD)

,Item,Group))

But this expression returning 0 for all records

any suggestions?