Formula to choose Dec value

Options
sandrajcp
sandrajcp Member, ALL USERS, Community Member Posts: 2 New Contributor
in Planning & Modeling

Hi All

 

I have one unit in my module that is missing a monthly phasing for 2 years (2022 & 2023). I have value only for December, so I want to say that if there is no input in a month, it should pick up Dec value and apply it to all months from January to November.

 

I'd prefer to avoid saying that if it's 2022 then take Dec 22 and if 2023 then Dec 23, so I'm wondering if there's a smarter way to solve it. I tried formulating using MONTH(START())=12, but no luck.

 

Thanks!

Tagged:

Categories