Data View Layout
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?
Accepted Answer
-
Thank you Helmut, this has solved my problem.
All the best,
Bruno
1
Answers
-
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,
Helmut0 -
Yes, between Feb.24 and Jan.24 but I also want to calculate the variance for the remaining months of that year.
KR,
Bruno
0 -
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,
Helmut0
