How to make my Revenue display +ve Sign ?

[paulyeo11]

Hi All

I use the below expression for TABLE (1) list the total amount for Exp IS WORKING FINE :-

Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},P_Exp={P_Exp}>}Amount*1)/1000, SOURCE))
,
$(vMoneyFormatK))

I use the below expression for TABLE (2) list the total amount for Revenue IS WORKING FINE , but i like to make the sign from -ve to +ve :-

Money(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},P_Revenue={P_Revenue}>}Amount*1)/1000, SOURCE))
,
$(vMoneyFormatK))

Paul Yeo

[paulyeo11]

Hi All

Enclosed my QVW

[Arthur_Fong]

Try this:

Money(
fabs(Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},P_Revenue={P_Revenue}>}Amount*1)/1000, SOURCE)))
,
$(vMoneyFormatK))