Formula to choose Dec value

Highlighted
New Contributor

Formula to choose Dec value

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!

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Formula to choose Dec value

Hey Sandra - May be a more elegant way but have you tried the method highlighted in the screenshots? 

 

 

values_dec.png

 

formulas_dec.png

 

Thanks.
JT

Highlighted
Super Contributor

Re: Formula to choose Dec value

Hi @sandrajcp 

You can create a line item formatted by time and map it to dec, 

then create a line item to select phasing value for the mnth if non zero else lookup the dec month line item value