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 employeeSeasonal 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)
Page: Product group
Line item: SeasonalPercentColumns: Time (Time scale has been set to month)
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.
Go to Solution.
It should be:
Month Sales.Monthly sales = YEARVALUE(Annual Sales.annual sales) * Seasonal Percentage.SeasonalPercent
View solution in original post