Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you just share a sample qvw .
it will be easy to help you .
Thanks
BKC
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
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
so it is not necessary to add some variables right ??
yes you dont need variables
if you want you can add .. its up to you
Thanks
BKC