Year values to months
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.