Previous Year to Date Calculation
Hi everyone,
I am in need of a formula for specific line items from our P&L that calculates the previous year's YTD values.
For example our YTD currently shows Jan 22 - May 22.
Ideally I could have a separate model to choose each line item and show the YTD for Jan 21 - May 21.
Is this possible?
Tagged:
0
Best Answer
-
I solved this just by using a separate model with the offset function and referencing each desired line item from the desired model, in combination with the YTD column.
0