Just to paint a background on what I’m trying to achieve here.
I’ve got a set of financial statements with 3 year historical numbers with I’ve set up into the income statement template and I have a set of assumptions that for future projections.
Currently, I’ve got no issues with setting up the historical financial statements in the canvas and the numbers appearing are correct.
However, when I look to add the future projections, I cant seem to get the numbers to appear in the correctly and in the correct location.
2020 onwards doesnt appear correctly for “MCN Revenue” line item.
In my “WTA line item actual” formula this refers to the bottom half of the formula.
Income Statement_v2.pbix (271.5 KB)
Please find attached the pbix file.
Thanks in advance for your help