-
Filter on Drilldown to only see items with data <> 0
Hello, I would like to ask if there's a way to make the drilldowns in Anaplan to only show items with data on them <> 0, or isnotblank? Currently, I need to scroll down a lot to locate to the account that has the relevant data. Thank you, Jonathan
-
Level 2 2.3.9.2 OFFSET formula
Hi i wrote this formula.It has taken without any errors but showing zeroes This is my formula IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET(Volumes, -52, 0) ELSE 0 Can u provide correct formula
-
Dynamic Cell Access by Role
I am looking for suggestions / alternative approaches for managing DCA by the user's assigned Role. Ideally, there would be an easy way to maintain this going forward. 1) I have heard a rumor that there is a trick wherein you somehow create a filtering module, then use the normal Roles>>Modules access assignments. Access…
-
Product list formula
Hi - P2 Product list has parent. Why formula is not pulling product family here?
-
L1 MB ExaM - Activity 3 - Import Data from Role.csv
I am getting the Invalid Parent error when uploading the Role.csv file to the new list created E3 Role. I understood the parent for the list would be E2 Employees. Any assistance greatly appreciated.
-
1.3.10.4 Check Your Work
Hello everybody I need your help please, I have a parent issue with my output I must have this : but actually i m having this : the probleme is the parent, actually, i verified the parent in general list and it's ok, G2 country is the parent of G3 location, like you can see: when i import the saved view for G3 location i…
-
PL Dashboard - Calculations in both Rows and Columns
Hi, I need to create a PL report/dash board where there are calculations in both rows and columns as in the attached screen. How can I achieve this. I have selections for Period, Year, Products and Region. Based on the period and Year selected, the data should show current YTD, prior YTD and % Change. These are part of…
-
How can I create an APP - Level 2 Sprint 2
Hi, I am in the middle of Sprint 2 of Level 2 MB, but I cannot see any link to create app on my app page. Do I have to ask for permission or this is what we can get in free trail log accounts for training. Thanks
-
How to get all periods totals with tiem dimenson in to a target module without time dimeson.
Hi All, I have asituation where I need to pul previous 4 years totals into another module which do not have time as dimenson. How can I achive this. My module screen shots are as below. Blueprint view of same The data needs to be pulled into blueprint view of same is Thanks for your help. Balrama Krishna
-
2.3.10 Create DEM03 Demand Forecast Module
I think I have successfully completed the section but I feel like there is something missing. Other than the Growth Rate %, I have no other values in the other line items. Am I missing something or are all other line itms intentionally blank/zeros? AM I missing the formulas?
-
Production plan
Hello ! I’m actually building a supply chain model in order to train after getting the certified model builder. However, I can’t figure out how to build a module that will provide me a production plan. I explain myself. I’m working on vegetables that are demand all along the year but that you can only harvest during a…
-
formula
How to get average prices from monthly data into Non months.
-
New Modeling Experience updates - February 2022
Hi everyone, We're pleased to offer some great new capabilities in the New Modeling Experience - check them out here: https://community.anaplan.com/t5/Feature-Updates/Explore-the-latest-updates-to-the-New-Modeling-Experience/ba-p/132843 Thanks
-
Sprint 3 - Activity Create Inventory Ordering / 3.3.5.3 Check Your Work
Dear Community, 3.3.5. Activity: Create Inventory Ordering/3.3.5.3 Check Your Work Please help with this activity... values are not matching, need solutions/formula hints to match the same.
-
Flagging different values at children for same parent
I am looking for an efficient solution for the following: * I have a module that is multiple levels, compound list - think of it as L1 and L2 * A line item within that list is an ID for each L2 * I would like to flag all L1 members that have multiple IDs for their respective children (L2). * In the screenshot, there are…
-
Dependent Dropdown by using filter
Hi, I want to use Dependent Dropdown list. I want to use Boolean Lineitem as "Filter Filter_Product based on data in " setting. Now I can filter by only 1 item. If we can this system, I can filter by 2 or more than items. In Anaplan, Can we achieve this?
-
Level 3 Model Builder Starter Model
Hi all, In Level 3 model building, the course says "you will download the Level 3 starter model. The starter model has some of the components already created.". Can anyone let me know where to download the starter model? Thanks,
-
Need Averages of months of prior years
Hi All, I have a situation where I need to get Average value of total sales in Jan17, Jan18, Jan19, Jan20 and Jan21 to be projected into Jan22 in a module. Please can anyone suggest how can I achive this. Thanks, Balarama Krishna
-
Workday function like excel
Hi, I want to use Workday function in Anaplan. It is used in Excel. In this page, we can built using a calculation. But I can not imagine how calculate it. https://help.anaplan.com/d61d7264-24d0-4357-adc6-64701b16c9aa-Excel-comparison:-W-functions Do you have any idea? Date1/11/21/31/41/51/61/71/81/91/101/111/12After 2…
-
Level 2- Sprint 3- INV01 Inventory Ordering Module
Could someone please tell me what I am doing wrong with these formulas. @Misbah 1. Beginning Inventory = IF 'SYS01 Time Settings By Week'.'1st Week of Timescale?' THEN 'DAT01 Beginning Inventory'.Beginning Inventory ELSE PREVIOUS(Ending Inventory) 2. Submit Purchase Order Request= OFFSET(PO Submitted, Shipping Time Weeks,…
-
Movingsum with boolean item
I want to use movingsum function. But I have a restrict of calender. 1月3日1月4日1月5日1月6日1月7日1月8日1月9日 value300400007000900 Workday☑☑ ☑ ☑ movingsum value2222222 Value(movingsum)14002000 ※Value(movingsum) = Movingsum( value, 0 ,movingsum value) If I used this formula, I can not consider workday. I want to achieve this sum…
-
Level 2 Sprint 3 Activity 3.3.5.5 (Final) Shipping Time Weeks
Hi, This thing is driving me nuts. My formula for "Confirmed PO Delivery" works when referring to the Shipping Time Weeks but won't work when referring to the Final Shipping Time Weeks. Both line items are formatted the same way. ggggrrrrr I would very much appreciate if somebody can tell me what is wrong. Michelle
-
Running total, No Timescale
Hi, I am in need of a solution to this dilemma and being new to Anaplan I can't think of way to write the formulas. The goal is to be able to pro-rate actual days work from days on leave. The PRO rate module has emp ID list and month time scale as the dimension and a whole host of line items to calculate start and end. And…
-
Determining A Line Item By Reference to Other Line Items
Hi all, I'm trying to do something that I think SHOULD work but I can't get it quite straight in my head so I'd appreciate some support. I've got a module that's holding employee data, dimensioned by Employee ID and by month. I need to be able to identify people managers, but the data extract doesn't have a flag for that.…
-
1.4.3.2 Import Data & Add Formula
Can someone help me figure out what formula I need here? All the columns are filled. What am I missing?
-
New Modelling Experience
There are so many things that I loved about new modelling experience but here are my top two picks which I loved the most. 1. Ability to open Lists, Line Item Subsets, Modules and Dashboards in their own tabs. This removes the need to go back and forth between Modules->Lists->Line item subsets. 2. Line item Subsets(LIS),…
-
how to add module
Hi All, I got access to the anaplan but my home page doesnt show anything even i am unable to add a new module as there is no option showing. Pl help. Regds, Chetan
-
Calculate the number of complete months between two dates (Similar to Excel DATEDIF Function)
Hello Community! Is there a way to calculate the number of complete months between two dates in Anaplan? E.g. Start Date (MM/DD/YYYY)End Date (MM/DD/YYYY)Number of Complete Months07/17/202007/16/20211212/03/202103/31/2022310/1/202112/31/20213 In the second row, even though the duration between 12/03/2021 & 03/31/2022 is 3…
-
How to find monthly average of Daily Totals?
I want to create the average of every month of a LI that displays Daily totals. One of the LI's will be my total account balances on a daily bases, and then I would want to create another LI that would show me the average of those daily total for each month. How would I go about this? Thank you
-
LOOKUP function with a version module
Hello all, I am facing a situation that seems weird to me. In a module, I want to repatriate the value of a forecast made last month. So I create a line item that uses the LOOKUP function : previous Fcst = Fcst Qty[LOOKUP: Param Version.Previous Version], Param Version is a system module that manages versions. It seems to…
