Previous Year to Date Calculation

CamdenMaggos
Contributor

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?

1 ACCEPTED SOLUTION

Accepted Solutions
CamdenMaggos
Contributor

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.

 

View solution in original post

1 REPLY 1
CamdenMaggos
Contributor

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.