How to make it can display +ve or -ve for net profit amount ?

[paulyeo11]

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

[paulyeo11]

Hi All

Enclosed my QVW file.

Paul Yeo

[Arthur_Fong · Accepted solution]

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))
)

[paulyeo11]

Hi Fong

Thank you very much for your help,

it work fine now.

Paul Yeo