Show yearly total every month over multiple versions
I have a module that calculates admin overheads variances between versions (actual, forecast, budget and prior month forecast).
I first created a module (PCAL01) that contains the data for all versions and then created a line item subset from this.
Next, I created a module that calculates the variance (POUT01) as seen below.
The first 3 line items are used to pull the data from PCAL01.
Everything works ok, apart from the 'Current Year' section where I want the module to display the total for that year. For instance if the total for this year is 100k, I want this displayed every month this year.
The subsidiary view for Data Year looks like this, so data is pulling across, but I am not sure if I am using the wrong formula.
Here is where you can see that 'Current Year' is not populated.
Any tips? I've been trying to resolve this for a while now… Thank you 😊
Best Answer
-
Because you are trying to pull value from a Line Item that is set to Year into a Line Item set to Month, try using YEARVALUE().
1
Answers
-
Thank you, it worked perfectly :)
0