Calculation Functions

Discussion List

• 
  Fetching Count and Sum Information different Reports

  vardhan_24 1 view 1 comment 0 points Most recent by vardhan_24 March 2019Planning & Modeling
• 
  Formula does not work in QA but in Dev

  imerchant 1 view 0 comments 0 points Most recent by imerchant February 2019Planning & Modeling
• 
  Lookup in Anaplan but with different dimensions

  aatan 1 view 0 comments 0 points Most recent by aatan February 2019Planning & Modeling
• 
  Test if a specific month is selected then do something

  ankiutel 1 view 3 comments 0 points Most recent by RHerz January 2019Planning & Modeling
• 
  How to Apply two dimensions

  SPratt01 1 view 0 comments 0 points Most recent by SPratt01 January 2019Planning & Modeling
• 
  How to override columns without using filter

  Moloy.singha 1 view 0 comments 0 points Most recent by Moloy.singha January 2019Planning & Modeling
• 
  How to hide column using formula

  moloysingha 1 view 0 comments 0 points Most recent by moloysingha January 2019Planning & Modeling
• 
  SUM Question...

  fpalomino 1 view 1 comment 0 points Most recent by fpalomino January 2019Planning & Modeling
• 
  Time List

  Prashant22may1 1 view 0 comments 0 points Most recent by Prashant22may1 January 2019Planning & Modeling
• 
  Formula to number a line item to create an order 1,2,3 etc.

  Dahya 1 view 1 comment 0 points Most recent by Dahya December 2018Planning & Modeling
• 
  Display Name User Selection

  Robert_Holmes 1 view 0 comments 2 points Most recent by Robert_Holmes December 2018Security
• 
  Lookup using another Lookup as reference

  jerrardli 1 view 0 comments 0 points Most recent by jerrardli December 2018Planning & Modeling
• 
  Users List as a basic Dimension

  Eugeny.Seledkov 1 view 0 comments 1 point Most recent by Eugeny.Seledkov December 2018Planning & Modeling
• 
  Best way to set current period (month/quarter/year)

  bskelly 1 view 1 comment 0 points Most recent by bskelly November 2018Extensibility
• 
  Slope formula as Excel

  rhernandez 1 view 0 comments 0 points Most recent by rhernandez November 2018Planning & Modeling
• 
  Anaplan to Tableau connection

  jamesbook 1 view 0 comments 0 points Most recent by jamesbook November 2018Extensibility
• 
  Allow users to add multiple numbers into a cell

  peter.gilfillan 1 view 0 comments 0 points Most recent by peter.gilfillan November 2018Planning & Modeling
• 
  Returning one line items value using other line items

  ryan.trottier 1 view 0 comments 0 points Most recent by ryan.trottier November 2018Planning & Modeling
• 
  Time Summary: MoM, QoQ, and YoY on the same line item

  patcharavtk 1 view 2 comments 0 points Most recent by patcharavtk November 2018Planning & Modeling
• 
  Months Spread

  jngo 1 view 1 comment 0 points Most recent by Surya.Arif November 2018Planning & Modeling
• 
  Countifs Function

  chseverson 1 view 0 comments 0 points Most recent by chseverson October 2018Planning & Modeling
• 
  How to avoid references to specific years in a formula

  michael_gould 1 view 0 comments 0 points Most recent by michael_gould October 2018Planning & Modeling
• 
  List subset by formula

  yoskaneko 1 view 0 comments 0 points Most recent by yoskaneko October 2018Planning & Modeling
• 
  Get prev year result

  MNHHS 1 view 0 comments 0 points Most recent by MNHHS October 2018Planning & Modeling
• 
  How can you "Paste Link" in Anaplan

  g_panayides 1 view 0 comments 0 points Most recent by g_panayides October 2018Planning & Modeling
• 
  Bulk Copy

  vijay_vyakarana 1 view 0 comments 0 points Most recent by vijay_vyakarana October 2018Planning & Modeling
• 
  Timescale related formulas

  yagna_mahadevan 1 view 0 comments 0 points Most recent by yagna_mahadevan October 2018Planning & Modeling
• 
  Anaplan's equivalent of a COUNTIF function

  robert_mahlum 1 view 0 comments 0 points Most recent by robert_mahlum October 2018Planning & Modeling
• 
  Changing Line Item Formula to Refer to List Subset Instead of List.Property

  cfoley 1 view 0 comments 0 points Most recent by cfoley October 2018Planning & Modeling
• 
  Drop Down List With A Way To Insert Another Line Item If Not In List

  tennyson_lee 1 view 0 comments 0 points Most recent by tennyson_lee October 2018Planning & Modeling