Copy month data
Dear, I have two questions regarding an implementation I'm currently working on. To give a little background information, it is a financial planning model for the coming 3 years and has a budget version and 4 different forecast versions. My questions are the following: [list=1]
- Copy data from one month into all months
- I have a module in which I have data in February
- I need to be able to copy the data I have in February to all the remaining months of the year
- (since this needs to happen every year, I cannot simply hardcode it as such '....'[SELECT:TIME.Feb 17] as this would only be valid for 2017 and not 2018
- Did anyone encounter the same issue and has a solution for this?
- Summarize periodic data to YTD data
- In another module of the model, I have periodic data from March to December.
- I need to somehow make this Year to date data, meaning that the value of:
- March = March
- April = March + April
- May = March + April + May
- June = March + April + May + June
- Anyone any experience on this?