Evolution pourcentage over years

[#1]

Hello there,

i am currently working with a file containing information per year

i have the list of region and number of roomnights. below this is the request of my business user.

Maybe it is because it is monday, but i can not figure out how to solve it ... could you please help ?

I was thinking about using variable like this

and the formula

fabs(
(
//Année MAX
SUM({$<YEAR={$(vYear)}>} [Nuitées (p.p.)])

// Année Max - 1
-
SUM({$<YEAR={$(vPrevYear)}>} [Nuitées (p.p.)])
// Année Max - 1 (Référentiel)
)
/
SUM({$<YEAR={$(vPrevYear)}>} [Nuitées (p.p.)])
)

But it is not working at all....thanks for your help

JP

[Anonymous]

can you just share a sample qvw .

it will be easy to help you .

Thanks

BKC

[teiswamsler]

Hi Jean-Philippe

try making a text box, set in  ='SUM({$<Année={$(vYear)}>} [Nuitées (p.p.)])' this will show you the calutation of the Variable in the set analysis..

/Teis

[Anonymous · Accepted solution]

for previous Year

Sum({$<Année = {$(=Max(Année)-1)}>}[Nuitées (p.p.)])

for current year or max year

Sum({$<Année = {$(=Max(Année))}>}[Nuitées (p.p.)])

Thanks

BKC

[#5]

so it is not necessary to add some variables right ??

[Anonymous]

yes you dont need variables

if you want you can add .. its up to you

Thanks

BKC