Additional Argument for TimeSum

Options
Dennis_Lucanas
Dennis_Lucanas Member, ALL USERS, Certified Master Anaplanner, Community Member, Certified Model Builder Posts: 5 Certified Master Anaplanner
in Planning & Modeling

I would like Anaplan to add a new optional parameters for Timesum. The formula would look like this, 

TIMESUM(x, [f] , [t], [a], [at], [ar])

wherein

  • [at] stands for aggregation type (simple, year on year). If omitted, default to simple
  • [ar] is the resulting value in absolute amount or percentage growth. If omitted, default to the absolute amount

This would be helpful in optimizing the formulas that are getting multiple years of historical data as the basis of calculation. Currently, I am doing it using nested IFs per year of data then collate those results to get the expected outcome.

 

For instance, 

simple, absolute amount=Timesum("Line Item.Revenue", Jan 18, Jan 19, Average,Simple,Absolute)
 Average of revenue from Jan 18 to Jan 19, resulting value in amount
simple, % growth=Timesum("Line Item", Jan 18, Jan 19, Sum,Simple,Growth)
 growth of revenue for period of Jan 18 and  Jan 19, resulting value in percent
yoy, absolute amount=Timesum("Line Item.Revenue", Jan 20, Mar 20, Average,3,Absolute)
 Average of revenue for Jan 18 to Mar 18;Jan 19 to Mar 19;Jan 20 to Mar 20, resulting value in amount
yoy, % growth=Timesum("Line Item.Revenue", Jan 20, Mar 20, Average,3,Growth)
 Average of revenue for periods Jan 18 to Mar 18;Jan 19 to Mar 19;Jan 20 to Mar 20, resulting value in percent

 

Tagged:

Categories