Implementing sumif in Anaplan using two different modules
I have one module containing of data from January 2010 to December 2020. In another module my dimension is not the Time period but a defined list of months. In these 12 columns of the second module, I want sum of January figures from data module to come in January column, sum of February figures from data module in February column and so on. Please help me with the same!
RE: Implementing sumif in Anaplan using two different modules
You need to map your 12 custom months to the standard periods by creating a "custom month" list formatted line item (list=your 12 months list) either in your data module directly or preferably in a "Time info" module. Enter the values manually or via a formula that reads the name of the time period, to put January (custom month) in each January cell (Jan 10, Jan 11,..Jan 20.)
Your target module needs to be dimensionned by time (month) and by your 12 months list. The formula in your target module will look like: Data module.value[SUM: Time info.custom month]
Re: RE: Implementing sumif in Anaplan using two different modules
The solution you proposed works but creates a lot of sparsity due to having both the true timescale and fake timescale as dimensions when you only want to populate data in the fake timescale.
In my case, my true timescale is in weeks and my fake timescale is in months. I want to sum the weeks into my months based on a mapping table. Do you have any suggestions for another way to do this without having weeks as a dimension in my target module?