Can't make =Only([YEAR]-1) working in the expression definition

[#1]

I am trying to display the cumulative sales for the current and previous year

In the label the expression "=Only([YEAR]-1)" seems to works correclty as show in the screenshot

But I can't make the expression "=sum( {$<Year = {$(=Only([YEAR]-1))}>} AMOUNT ) " working, it always evaluate the current year.

Am I doing anything wrong ?

/Eric

[jfkinspari]

Try and move the "-1" out of the only function like this

"=sum( {$<Year = {$(=Only([YEAR])-1)}>} AMOUNT ) "

[#3]

Hi

sum({<YEAR={$(=only(YEAR)-1)}>}[Net Amount])

it show values only when u select the year

otherwise it show all 0,s

u must select the one year for it

[nirav_bhimani]

HI ,

Try this Expression.

Current Year Sales:

sum({<Year= {"$(=Max(Year))"}>} AMOUNT )

Last Year Sales:

Sum({<Year = {"$(=Max(Year )-1)"}, Quarter=, Year=>} AMOUNT )

Regards,

Nirav Bhimani

[#5]

Hi,

That did not change anything

[#6]

I ahve a list box property where I select the [YEAR] attribute.

[#7]

The max year did not solve the problem, could it be that my data is corrupted ?

[nirav_bhimani]

Hi,

Both expressions will work. Can u share a demo file so that I can help you.

Regards,

Nirav Bhimani

[#9 · Accepted solution]

Hi

u select the year in ur  year field what ur using in the expression

sum({<YEAR={$(=only(YEAR)-1)}>}[Net Amount])

[#10]

Thanks a lot, I add one characters $ that was not needed