Hi
Can someone please help me to understand the diffrent step in this expression
rangesum(Sum(OutcomeCurrentYear),above(Sum(OutcomeCurrentYear),1,rowno())))/rangesum(Sum(OutcomePrevYear),above(Sum(OutcomePrevYear),1,rowno()))-1)
It´s a chart that shows the accumulative % change of the outcome bewteen months
The field OutcomeCurrentYear and OutcomePrevYear is a total sum of Outcome for MTPID 1 and 2 created in the script year by year.
My problem is that I now have to remake it in another qvw where the sum field OutcomeCurrentYear isn´t created in the script year by year. Instead there are a mastercalendar and I have the field MTPID and outcome row by row. I guess I have to do something with a set analys but can´t get it to work. Any help would be welcome
Edit
I have this
(
sum(aggr( rangesum( above( Sum({<Year=, Year={$(=max(Year))},MTPID= {1,2} >} Utfall*-1),0,12) ),Month))
/
sum(aggr( rangesum( above( Sum({<Year=, Year={$(=max(Year-1))}, MTPID = {1}, >} Utfall*-1),0,12) ),Month))
)
Then I´m close but I don´t think it work. Ie I get 1,06 I need it to be 6%, I get 1,02. I need it to be 2%