Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below expression work fine when i select Revenue and Exp :-
Money(
fabs(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
)
,
$(vMoneyFormatK))
When i am not select Revenue and Exp , it should display net profit amount. since the expression is with Fabs , it alway display positive which is wrong. Hope some one can advise me how to make it able to display +ve or -ve ?
Paul Yeo
if(GetSelectedCount([Pls select 901st Dim])<1,
Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
,
$(vMoneyFormatK)),
Money(
fabs(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
)
,
$(vMoneyFormatK))
)
Hi All
Enclosed my QVW file.
Paul Yeo
if(GetSelectedCount([Pls select 901st Dim])<1,
Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
,
$(vMoneyFormatK)),
Money(
fabs(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
)
,
$(vMoneyFormatK))
)
Hi Fong
Thank you very much for your help,
it work fine now.
Paul Yeo