4 Replies Latest reply: May 25, 2016 7:09 PM by Yeo Poh sai

# How to change the meansure from sales to rEVENUE in SET expression?

Hi All

My Chart 1 Expression as below  working fine :-

Sum({<year = {\$(=Max(if(getselectedcount(year)=0,2015,year))-1)}

,

month = {"<=\$(=Max({<year={\$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}

>} sales/\$(Columndim89)/1000)

Now i like to replace sales with nET_PROFIT as below :-

Sum({<nET_PROFIT={"nET_PROFIT"}>}Amount)

I try below expression in chart 2 :-

Sum({<year = {\$(=Max(if(getselectedcount(year)=0,2015,year))-1)}

,

month = {"<=\$(=Max({<year={\$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}

>} ({<nET_PROFIT={"nET_PROFIT"}>}Amount)/\$(Columndim89)/1000)

it does not work.

Paul

• ###### Re: How to change the meansure from sales to rEVENUE in SET expression?

my QV Doc

• ###### Re: How to change the meansure from sales to rEVENUE in SET expression?

Not sure, but may be this?

Sum({<year = {\$(=Max(if(getselectedcount(year)=0,2015,year))-1)}

,

month = {"<=\$(=Max({<year={\$(=Max(if(getselectedcount(year)=0,2015,year)))}, sales = {'*'}>} month))"}, nET_PROFIT={"nET_PROFIT"}

>} Amount/\$(Columndim89)/1000)

• ###### Re: How to change the meansure from sales to rEVENUE in SET expression?

Hi sunny

Thank you very much . The chart display the figure I need . So it must be correct . I can move on doing the report I need.

I will tick correct answer after I finish my dinner .

Paul

Sent from my iPhone

• ###### Re: How to change the meansure from sales to rEVENUE in SET expression?

just to move this post to more recent post.