
Modeling
Modeling
Discussion List
- Hi Team, As Anaplan came up with the auto logout feature, it is good from the safety point of view. But its quite annoying most of the times. As a developer we get involved in multiple other tools and…
- As a user I should not have to configure Outlook to use commas as a delimiter for sending to multiple recipients as this option is not checked by default. The MAILTO function in Anaplan only accepts c…
- How do you create a 13 period year where P13 is added into Q4?
- Hi, How do I filter this module to display only the first occurrence of PR No (4th column). PR No is text and its derived from using formula LEFT (PR List, 😎 . PR List (the 1st column) is a composite…
- Hi There, I was wondering if you can point me in the right direction on finding how to do the below 😃 I am trying to build a report that can show me just the Vendor that make the 70% of the Total Exp…
- Hi guys, please help. attached a pic. Is it possible to sum up "values" this way, to have the result in "values months" column? - january : values from january - february : values from january and feb…
- Hello all, How can I get the month where the switchover week-end falls under? I've tried several things, not getting the desired output, yet. Thanks!
- Hi All, Is it possible to allocate the 53rd week in a 445 arrangement to a different year? Example; from FY20 to FY19 and from FY25 to FY24
- Hi, I've created a module that contains a list with data that has 3 components of a list concatenated (to limit the number of rows). The list data looks like this: CCCC_AAAAAA_DDD - with the C's being…
- Hi - I am new to Anaplan and I have a quick question: Let's presume we are to develop a supply chain demand planning module for a client. Since we exactly know what all lists/line items are needed alo…
- Hi All, I feel that the summary methods in Anaplan could be improved further by including more flexible options to use other line items (same dimensionality) to influence summary method. For example o…
- hi In production optimization formula given for C3: Constraints i have written as it is given in dashboard but still it shows erroe when run optimiser. i I have attached screenshot of the error and fo…
- Hi. We are trying the Statistic forecast. In monthly model, we need to set parameters to run the statistic model. (Like Holt's α in Holt's Winters model) But this setup is manual input. Can we calcula…
- Hello all, I am working on Level 1 activity 8.5.3. I imported the file without any problem but my numbers are different from the screenshot given by the course module. Could you please help me with th…
- Hi, The following formula below is giving me a Circular Reference when it should not be. Please advise on how to avoid this error. The LI that this Formula is in is Acutal and Projected 30 + $ Curve. …
- It will be good to have ability to change an import name the same time when you first create the import. For example, having a special field on import setting window, like in screenshot.
- Hi, Is there a way i can get native version to a lineitem in text format ? Similar to using name(item(List)). Regards, Tom
- Current business model: Have monthly beginning Inventory + beginning inventory $ value (+ production/-usage) calculating ending inventory lbs. & $. Ex: July beginning Inventory 100K lbs. & $100K value…
- Hi, I'm trying to do something which I think should be very simple but which I just can't seem to get working in Anaplan. I have two modules with exactly the same dimensions, except one has a time dim…
- Hello all, Imagine we have a parent list Country (G1) and two child list attached to this list: Fisrt list => Regions (G2) and a second list Stores/Entities (G2 bis). We need this second list Digital …
- The "Line Items" tab is a really handy view when reviewing a model and looking through multiple line items across different modules at the same time. You can currently access the formulas by double-cl…
- Hi, I am facing issue in trying to reference the same item of prev row. For example, This is the Excel formula for a line item ‘Calendar Month’ : IF Calendar month of prev row = 12 THEN 1 ELSE Calenda…