Data View Layout

Bruno · 2025-01-23T14:15:46+00:00

There was an error rendering this rich post.

Hi everyone, hope you're all well! I was hoping someone could show me how I would go about creating a variance value between each individual month for and entire calendar year ? I have created an algorithm block for Net Investment and then created a 2nd block using the same algorithm to set it as the prior month value, however, in my data view my prior month data block and current month data block is showing the same value… Which means my variance is 0?

Find more posts tagged with

Accepted answers

Bruno

Thank you Helmut, this has solved my problem.

All the best,

Bruno

All comments

Helmut Heimann

Hi @Bruno ,

did I understand you correctly that you want to calculate the variance between i.e. Feb.24 and Jan.24, or shall it be between Feb.24 and Feb.23?

Best,
Helmut

Bruno

Yes, between Feb.24 and Jan.24 but I also want to calculate the variance for the remaining months of that year.

KR,

Bruno

Helmut Heimann

Hi @Bruno ,

then first of all you need to make sure that the cube is dimensioned by that entity (in your case "Month"). Perhaps you will need to aggregate the data if your cube is dimensioned by day.

The two blocks to calculate the variance from are then defined as in this example (my cube is dimensioned by day):

The outcome would be like

That would include all months (or days) of the selected period.

You'll always need the period offset of "-1", referring to the previous period.

Best,
Helmut

Bruno

Thank you Helmut, this has solved my problem.

All the best,

Bruno