Sum(Aggr()) don't work in custom table

[#1]

Hi all,

I have the following expression :

Sum(Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))

This expression sum the total accsale all store. It is ok for text box and straight table. But I use for the custom table that isnt work.

Can anyone help me??

it's straight table

it's the custom table

Thank in advance.

[jagan]

HI,

Try this

Sum({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>}  Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))

Regards,

Jagan.

[#3]

it still isnot work

[Anonymous]

I think you create a new table and add expression again hope it works

[#5]

kirkleehuang‌ : I try your solution but It doesnt worrk

[swuehl · Accepted solution]

Maybe you get what you want using the TOTAL qualifier:

  //3

    ,Sum(TOTAL Aggr( Max({<Quarter={"$(vPriorQuarter)"} , Month={"$(vPriorMonth)"} , WeekYear={"$(vPriorWeek)"} , Date={"$(vPriorDate)"}>} AccSales),StoreName))

[#7]

Hi swuehl‌ ,

Thank you so muchhhh ......