Calculation Functions

Discussion List

• 
  How show first ten items in a chart/table

  Zoya 1 view 2 comments 0 points Most recent by Zoya May 2020Planning & Modeling
• 
  ITEM formula for on flat list

  CommunityMember117741 1 view 2 comments 0 points Most recent by CommunityMember117741 May 2020Planning & Modeling
• 
  Additional Argument for TimeSum

  Dennis_Lucanas 1 view 0 comments 10 points Most recent by Dennis_Lucanas May 2020Planning & Modeling
• 
  Delete line items based on time period

  aabalos 1 view 0 comments 0 points Most recent by aabalos May 2020Planning & Modeling
• 
  Assign the module name for the line item

  qsong1 1 view 1 comment 0 points Most recent by qsong1 May 2020Planning & Modeling
• 
  Calculation within the list

  Vladimir 1 view 1 comment 0 points Most recent by Vladimir April 2020Planning & Modeling
• 
  Advice how to structure rolling forecast formula with time element

  ChristinePowell 1 view 0 comments 0 points Most recent by ChristinePowell April 2020Planning & Modeling
• 
  Color Theme Formulas

  jeremy_stern 1 view 0 comments 0 points Most recent by jeremy_stern April 2020Planning & Modeling
• 
  SUM vs LOOKUP - Visual Representation

  MCRIST 1 view 1 comment 2 points Most recent by MCRIST April 2020Planning & Modeling
• 
  Level 1 MB Lookup function issue

  Vincent 1 view 0 comments 0 points Most recent by Vincent April 2020Planning & Modeling
• 
  Picking up opening balance

  AdeleDu 1 view 0 comments 0 points Most recent by AdeleDu April 2020Planning & Modeling
• 
  Summary setting for module dimensionalized by years and fake months list

  moriahreyes 1 view 0 comments 0 points Most recent by moriahreyes April 2020Planning & Modeling
• 
  Filtering line items or lists by another list

  moriahreyes 1 view 0 comments 0 points Most recent by moriahreyes April 2020Planning & Modeling
• 
  transform data's timescale

  AdeleDu 1 view 0 comments 0 points Most recent by AdeleDu April 2020Extensibility
• 
  Importing data Module-to Module

  vlaxmi1 1 view 1 comment 0 points Most recent by vlaxmi1 April 2020Extensibility
• 
  issue in anaplan level 2 training content. Help!

  mishras@deloitte.com 1 view 0 comments 0 points Most recent by mishras@deloitte.com April 2020Planning & Modeling
• 
  Sum by Parent

  BenBerube 1 view 0 comments 0 points Most recent by BenBerube April 2020Planning & Modeling
• 
  MBL2: Conclusion INV05 Shipping Export

  Olli 1 view 2 comments 0 points Most recent by Olli April 2020Planning & Modeling
• 
  SUM in conjunction with boolean filter

  PaulWestonVA 1 view 2 comments 0 points Most recent by PaulWestonVA March 2020Planning & Modeling
• 
  Previous year unitary calculations and summing

  mikhivin 1 view 1 comment 0 points Most recent by mikhivin March 2020Planning & Modeling
• 
  Is Parent Boolean

  Blake_R 1 view 2 comments 0 points Most recent by Blake_R March 2020Planning & Modeling
• 
  Sum with conditions

  mikeng 1 view 0 comments 0 points Most recent by mikeng March 2020Planning & Modeling
• 
  Mailto function won't open Outlook / Mail app

  EHarris 1 view 0 comments 0 points Most recent by EHarris February 2020Planning & Modeling
• 
  How to make Date as a Display name in a Numbered list?

  mary8919 1 view 1 comment 0 points Most recent by mary8919 February 2020Planning & Modeling
• 
  Excel user defined functions

  dermot 1 view 2 comments 0 points Most recent by dermot February 2020Planning & Modeling
• 
  Level 1 Model Building : Margin and Margin % in Rep02 Size Margin Report

  mary8919 1 view 0 comments 0 points Most recent by mary8919 February 2020Planning & Modeling
• 
  Circular Reference when using a line item as input

  CommunityMember131269 1 view 3 comments 0 points Most recent by CommunityMember131269 February 2020Planning & Modeling
• 
  Referencing Batches of Same SKU to calculation QTY of expiring materials

  jedge@dsi.com 1 view 1 comment 0 points Most recent by jedge@dsi.com February 2020Planning & Modeling
• 
  Find the minimum contract quantity falling within a contract range

  Vignesh Mohan 1 view 0 comments 0 points Most recent by Vignesh Mohan February 2020Planning & Modeling
• 
  Property in List using a formula

  iWonder 1 view 4 comments 0 points Most recent by iWonder February 2020Planning & Modeling