Problems with set expression vMaxYearMonth - vPreviousMonth / period quantities

[JMA_1]

Hey,

My goal is to have period quantity figures when I already have the cumulative ones.

I have set the following variables

Variables

The formula that I used in expression:

Expression'

The end result you will find below:

Result

Period quantity expession is not working as I wanted to. Cumulative quantity expression (=sum(TOT_Määrä) work just fine.

Could you guys help me with this problem?

[balabhaskarqlik]

Try this:

Sum({<YearMonth = {'$(=vMaxYearMonth)'}>}TOT_Maara) -
Sum({<YearMonth = {'$(=vPrevYearMonth)'}>}TOT_Maara)

[JMA_1]

Thank you for your response but it didn't sovle the problem.