why the table overall total amount dis-appear when compute in eXP ?

[paulyeo11]

Hi All

I have a Table , when i click on display in Org or S$ currency , the Table able to display summary total amount. The minute when user select the compute by eXP , the overall total amount disappear.

Any reasons why ?

Paul

[paulyeo11]

Enclosed my QV Doc

[sunny_talwar]

What is the expected total you would want to see?

[paulyeo11]

Hi sunny

I expected to see 312.85 on 2016 and 338.85 on 2015.

[sunny_talwar · Accepted solution]

Check now

Money(Pick(

Match([Pls select 601st Dim],'rEVENUE','sales','cost','profit','eXP','nET_PROFIT','nET_PROFIT'),

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/$(Columndim89)/1000,

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000),

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}cost/$(Columndim89)/1000),

Sum({$<year = {$(=Max(year)-1)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}profit_amt/$(Columndim89)/1000),

Sum(Aggr(SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},eXP={eXP}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim101))),

SUM({<year = {"$(=Max(year)-1)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},nET_PROFIT={nET_PROFIT}>}Amount*1)/$(Columndim89)/1000,

Sum({<$(ColumnDim601)={$(ColumnDim601)}>}Amount)/$(Columndim89)/1000),

$(vMoneyFormatK))

[paulyeo11]

Hi sunny

your mind very sharp.

Thank you

Paul

[paulyeo11]

Hi Sunny

By the way , when combine all SOURCE data how come you know need to add Aggr ?

Paul

[sunny_talwar]

Whenever the issue is with total, it usually boils down to a need for Aggr() function.