New Contributor

## 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Certified Master Anaplanner

## Re: Simple seasonalization question

It should be:

Month Sales.Monthly sales = YEARVALUE(Annual Sales.annual sales) * Seasonal Percentage.SeasonalPercent

Thanks,

LipChean

2 REPLIES 2
Certified Master Anaplanner

## Re: Simple seasonalization question

It should be:

Month Sales.Monthly sales = YEARVALUE(Annual Sales.annual sales) * Seasonal Percentage.SeasonalPercent

Thanks,

LipChean

New Contributor