Simple seasonalization question
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.
Comments
-
Perfect! Thanks for your help.0
Categories
- All Categories
- 2.3K Anaplan Community
- Academy
- Anaplan Talent Builder
- Model Design Course
- The Anaplan Way
- Archive
- 2 Idea exchange
- 62 Enterprise Scale
- 1.1K Extensibility
- 21 Intelligence
- 1.6K Planning & Modeling
- 331 Security
- Community Connections
- Connections
- Experiences
- Groups
- Personas
- Employees
- CS Toolkit
- Customer Care Center
- Forums
- Academy & Training
- Community Feedback & Updates
- Japan
- Anaplan Community Japan
- Anaplan Community Japan Knowledge Base
- HyperCare Japan
- JP-Central
- Support-Japanese
- Partners
- Partner Leadership Council
- Partner Product Council
- 724 Platform
- Anapedia
- App Hub
- Centers Of Excellence
- Extensions
- Planual
- Platform Updates
- 724 User Experience
- Profile Builder
- Resources
- Anaplan Advocates
- Anaplan Live!
- Community
- Community Advancement
- Community Connections
- Partner Program
- The Official Master Anaplanner Program
- Videos
- Welcome to the Anaplan Community!
- Success Central
- Support
- Case Portal Link
- Common Support Questions
- HyperCare Redirect
- Known Issues and Workarounds
- Support test page
- SupportFAQ
- Survey
- 2 Training Day Takeaways