Year values to months

Sachinsourav02

Anaplanners, 

 

For an input screen, I want to enable users to input at a yearly level and then I want that same value to flow to every month pertaining to that year automatically.  This is to make life easier for the end user to not input data at a monthly level, rather do one input at the year. 

 

Example. Value for FY 20:- 1000. Then Jan-dec 20 would have 1000 each.

 

I created an input screen by year with same dimension as that of the month module and now I wish to create an action to take data from year module to that of month module. However the mapping stops me from directly copying over data. 

 

I didn't go the formula route because I want the end user to still have the ability to edit if they wish to make changes to the numbers. Can this be done in the way above that is receive input at yearly level and then disaggregate the numbers. 

 

Thanks

KirillKuznetsov

Hi @Sachinsourav02 

What if you go with formula way, but add another line item for overwrite?

It will be much cleaner picture having initial data and below the edited line.

	jan	feb	mar	apr	may
Year base	1000	1000	1000	1000	1000
Overwrite?	TRUE	TRUE	FALSE	TRUE	TRUE
Overwrite	1200	900		400	0

Note: if you need to zero down - most common approach is to make an if statement where 0.00001 = 0. Or just an additional boolean line item (as in May on the table)

 

If you still want the import. You will have to use "the formula way" anyway, but as a precalc line item dimensioned by months. From this line item you will do the import.

But this way you will have to consider if anyone would ever want to change this initial year value and push the button to re-write monthly - it may cause dataloss of the overwrites made by others.

So taking in account the above, I would prefer the first option with overwrite line.