I am having trouble interpreting Anapedia's Time Aggregation functionality which states that: X = YEARVALUE(Y) * Seasonality% Will allocate Y according to a seasonality percentage (not shown). I have the following simple example with three modules: Annual sales by product group and employee Seasonal percentages by product group Monthly sales by product group and employee Module: Annual sales Page: Product group, Employee Line item: Annual sales Columns: Time (Time scale has been set to Year; calendar type Calendar month/quarter/year used) Module: SeasonalPercentages Page: Product group Line item: SeasonalPercent Columns: Time (Time scale has been set to month) Module: MonthlySales Pages: Product group, Employee name Line item: Monthly sales Columns: Time (Time scale has been set to month) My question: What is the correct formula for line item Monthly sales? Recognizing that the employee does not affect sales seasonality, my first cut is as follows: AnnualSales.Annual Sales * SeasonalPercentages.MonthlyPercent An Excel spreadsheet with a visual example of this issue is attached.
... View more
Is it possible to directly plan annual values only using calendar type Calendar month/quarter/years? I have completed the Level 1 modeling course and all the examples there plan on the basis of individual months (Time being placed in the columns of the module definition) so I am very much feeling my way on this. Here's the input module that I would like to create: Page: Product number Line item: Annual sales Columns: 2020, 2021, 2022, 2023, 2024 This question is about entering yearly values, not displaying yearly values once monthly values have been entered. Thanks
... View more