Calculation Functions

Discussion List

• 
  Request Enhancement - reference the Year from the Current Fiscal Year set in Time

  vazqulu1 1 view 0 comments 0 points Most recent by vazqulu1 February 2021Planning & Modeling
• 
  Date formula: Month +3, Day -1

  lhidden 1 view 1 comment 0 points Most recent by lhidden February 2021Planning & Modeling
• 
  IRR & NPV Calculations with Initial/Start Date

  Vinaygvk7 1 view 1 comment 2 points Most recent by Vinaygvk7 February 2021Planning & Modeling
• 
  safety stock flag count: sprint 3 level 2

  Aneetabj 1 view 1 comment 0 points Most recent by Aneetabj February 2021Planning & Modeling
• 
  DEMO 03 Demand Forecast. Baseline Forecast formula

  Manohar 1 view 5 comments 0 points Most recent by kyaahiyar February 2021Planning & Modeling
• 
  Missing Data in Production Model

  stiwrx1 1 view 3 comments 0 points Most recent by luicasmora February 2021Planning & Modeling
• 
  Time Function in Anaplan

  g.mahesh 1 view 1 comment 0 points Most recent by g.mahesh February 2021Planning & Modeling
• 
  Formula

  Human008 1 view 4 comments 0 points Most recent by Human008 February 2021Planning & Modeling
• 
  Pull data into current year from previous year where both are list items

  NabajitBharali 1 view 1 comment 0 points Most recent by James Dougan February 2021Planning & Modeling
• 
  Level 2 Sprint 3 Exam

  Steve_Newell_Vuealta 1 view 0 comments 0 points Most recent by Steve_Newell_Vuealta February 2021Planning & Modeling
• 
  Average of Every Monday

  SwathyShankar 1 view 2 comments 0 points Most recent by SwathyShankar February 2021Planning & Modeling
• 
  FIRSTOCCURANCE should happen based on High number

  g.mahesh 1 view 0 comments 0 points Most recent by g.mahesh February 2021Planning & Modeling
• 
  Stagging List

  g.mahesh 1 view 0 comments 0 points Most recent by g.mahesh February 2021Planning & Modeling
• 
  Filter Full Year

  Muh_Arief 1 view 3 comments 0 points Most recent by Muh_Arief February 2021Planning & Modeling
• 
  Forecast Function in Anaplan

  roshinrasheed 1 view 1 comment 0 points Most recent by arti.kalekar1 February 2021Planning & Modeling
• 
  REV03 Margin Calculation

  HabaCaroline 1 view 0 comments 0 points Most recent by HabaCaroline February 2021Planning & Modeling
• 
  Collect () function with multiple/varying formats

  CommunityMember113866 1 view 2 comments 3 points Most recent by CommunityMember113866 February 2021Planning & Modeling
• 
  How to count in which number a particular date will come

  saurav4ss 1 view 0 comments 0 points Most recent by saurav4ss February 2021Planning & Modeling
• 
  'SYS08 Employee Details'.Region

  Wade 1 view 1 comment 0 points Most recent by Wade January 2021Planning & Modeling
• 
  Create a Formula to Reference a User's Model Role

  rachel_goering 1 view 4 comments 24 points Most recent by VaibhavMaini23 January 2021Security
• 
  Taking an average of specific Quarters, like all Q1 or all Q2 over many years

  CommunityMember123764 1 view 4 comments 0 points Most recent by CommunityMember123764 January 2021Planning & Modeling
• 
  Alert Model Builders of Incorrect Formulas/References Prior to Testing

  Ksimek 1 view 0 comments 31 points Most recent by Ksimek January 2021Planning & Modeling
• 
  Function to return the number of leaf items in a standard or numbered list.

  justin.filip 1 view 0 comments 0 points Most recent by justin.filip January 2021Planning & Modeling
• 
  Fully connected planning for contact centres

  gazwillott 1 view 0 comments 0 points Most recent by gazwillott January 2021Extensibility
• 
  Ignore Timescale as a dimension if Time formatted mapping line item is used for aggregation

  Eugeny.Seledkov 1 view 0 comments 2 points Most recent by Eugeny.Seledkov January 2021Planning & Modeling
• 
  It would be helpful to have an “aggregation operator” property that would apply to a hierarchy.

  dsoomar 1 view 0 comments 1 point Most recent by dsoomar January 2021Extensibility
• 
  SET CHECKBOX value through a given condition

  jbaudino1 1 view 0 comments 0 points Most recent by jbaudino1 January 2021Planning & Modeling
• 
  DCA based off of a user in a module

  CommunityMember122229 1 view 1 comment 0 points Most recent by CommunityMember122229 January 2021Planning & Modeling
• 
  Circular Reference with CUMULATE

  shrey 1 view 2 comments 0 points Most recent by shrey January 2021Planning & Modeling
• 
  Deriving the month/quarter value from the line item

  praba71 1 view 1 comment 0 points Most recent by praba71 January 2021Planning & Modeling