Calculation Functions

Discussion List

• 
  Optimizer Constraints

  Srithal 1 view 0 comments 0 points Most recent by Srithal September 2019Planning & Modeling
• 
  Formula to get name of a boolean formated line item .

  Axel 1 view 1 comment 0 points Most recent by Niranth September 2019Planning & Modeling
• 
  Formula Summary Method for List

  AshaPatil 1 view 0 comments 0 points Most recent by AshaPatil August 2019Planning & Modeling
• 
  Retrieve Numbered list' Display Name

  gregoryTan 1 view 2 comments 0 points Most recent by gregoryTan August 2019Planning & Modeling
• 
  Need formula help to calculate YEARTODATE -1

  phanishashank 1 view 4 comments 0 points Most recent by phanishashank August 2019Planning & Modeling
• 
  Use Time Ranges in formulas: Make the Time Range a named member in the Time Dimension

  amy_martin_1 1 view 0 comments 0 points Most recent by amy_martin_1 August 2019Planning & Modeling
• 
  Input values based on a Boolean formatted Time Period

  CommunityMember88511 1 view 1 comment 0 points Most recent by CommunityMember88511 August 2019Planning & Modeling
• 
  Formula Error Log

  mweinzim24 1 view 0 comments 0 points Most recent by mweinzim24 August 2019Planning & Modeling
• 
  List Property in Text and referring the text from Module as List formatted

  gregoryTan 1 view 0 comments 0 points Most recent by gregoryTan August 2019Planning & Modeling
• 
  Circular Reference - calculating average

  RdenUijl 1 view 3 comments 0 points Most recent by RdenUijl August 2019Planning & Modeling
• 
  How do I sum across dimensions other than time?

  iosman123 1 view 0 comments 0 points Most recent by iosman123 July 2019Enterprise Scale
• 
  Avoiding circular references with calculations on Previous List Item (Numbered List)

  chris_liassides 1 view 3 comments 0 points Most recent by chris_liassides July 2019Planning & Modeling
• 
  Numbered Lists

  Adhvi.Panata 1 view 1 comment 0 points Most recent by Adhvi.Panata July 2019Planning & Modeling
• 
  How to bring in previous balance into current module? Or how do I bring in a rolling balance forward

  kdoan 1 view 1 comment 0 points Most recent by kdoan July 2019Extensibility
• 
  Subtracting Months when using lookup

  C0000 1 view 4 comments 0 points Most recent by C0000 July 2019Planning & Modeling
• 
  Is it possible to have 2 different formula on the same line item?

  kdoan 1 view 0 comments 0 points Most recent by kdoan July 2019Planning & Modeling
• 
  SUM function usage on different dimensionality

  VarshniR 1 view 4 comments 0 points Most recent by VarshniR July 2019Planning & Modeling
• 
  What is Branch?

  Marble_Rock 1 view 2 comments 0 points Most recent by Marble_Rock July 2019Extensibility
• 
  Need to create multiple version comparison

  rtriguer 1 view 0 comments 0 points Most recent by rtriguer July 2019Planning & Modeling
• 
  Line Items Not at the Hierarchy of the Line Item Subset

  iosman123 1 view 0 comments 0 points Most recent by iosman123 July 2019Planning & Modeling
• 
  Additional History Filtering in a model, plus history extraction/access

  Andrew_Nivison 1 view 1 comment 0 points Most recent by HajniKotvics July 2019Enterprise Scale
• 
  Formula

  UMAMAHESH 1 view 0 comments 0 points Most recent by UMAMAHESH July 2019Planning & Modeling
• 
  Get Value of Top Level

  drushford 1 view 3 comments 0 points Most recent by nickstock July 2019Planning & Modeling
• 
  How do I sum across dimensions other than time?

  iosman123 1 view 0 comments 0 points Most recent by iosman123 July 2019Extensibility
• 
  Fiscal Calendar Lookup

  taylor.swisher 1 view 0 comments 0 points Most recent by taylor.swisher July 2019Planning & Modeling
• 
  COUNTA formula in Anaplan

  guidopolisena 1 view 1 comment 0 points Most recent by guidopolisena June 2019Planning & Modeling
• 
  System Default date

  prasadaav 1 view 0 comments 0 points Most recent by prasadaav June 2019Extensibility
• 
  Simple yearly average

  stewart.jardine 1 view 3 comments 0 points Most recent by stewart.jardine June 2019Planning & Modeling
• 
  Sum one Line Item based on the value of another Line Item

  gordon_sneddon 1 view 3 comments 0 points Most recent by gordon_sneddon June 2019Planning & Modeling
• 
  Data Split

  mayaaz 1 view 1 comment 0 points Most recent by mayaaz June 2019Planning & Modeling