Faild to use aggr expression in another expression of the same straight table

[seWork]

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?

[PrashantSangle · Accepted solution]

why need another aggr() & sum. Just add it inside existing formula

try like,

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

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

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

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

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

or 

just simply multiply vol with existing 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)  * Vol

Regards,