Sum values based on period

Highlighted
Occasional Contributor

Sum values based on period

Hi,

 

Need a help to build a formula, have attached a screenshot for reference. Formula Needs to be build in Revenue Seasonality which need to take the values from Revenue Column and doing the sum of Periods.

 

For Example: Period 1 amounts: 112+ 95. Needs to be clubbed as 207 and shown in Revenue Seasonality against all the Period 1. Similar goes for rest of the periods.

 

Thanks. 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Sum values based on period

@CommunityMember128917 

Several ways you can accomplish this.

  1. First is to use TIMESUM.
  2. Second is to use a boolean on each of the time periods you want included. Can be dynamic if you want Then multiply the value times the 1 or 0 to sum up the preferred sales.

 

Here's an example of TIMESUM:

Sales by product:

TimeSum001.png

Sales using TIMESUM. Note that the "Sum" line item doesn't work because you can't directly refer to the line item on the Time dimension.

TimeSum002.png

Blueprint mode

TimeSum003.png


Jared Dolich
Highlighted
Super Contributor

Re: Sum values based on period

Hi @CommunityMember128917 ,

 

Since your period is a list formatted line item , it establishes a mapping between time and period list, 

so simply use Revenue[sum:souce.period] and it will aggregate against period dimension in target module