# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for
Did you mean:
Highlighted Master

## How to make my Revenue display +ve Sign ?

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

2 Replies
Highlighted Master

## Re: How to make my Revenue display +ve Sign ?

Hi All

Enclosed my QVW

Highlighted Partner

## Re: How to make my Revenue display +ve Sign ?

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