Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
Enclosed my QV Doc
What is the expected total you would want to see?
Hi sunny
I expected to see 312.85 on 2016 and 338.85 on 2015.
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))
Hi sunny
your mind very sharp.
Thank you
Paul
Hi Sunny
By the way , when combine all SOURCE data how come you know need to add Aggr ?
Paul
Whenever the issue is with total, it usually boils down to a need for Aggr() function.