I'd like the ability to allow users to fill out a Form in the new UX and create a code for the new item (automatically) based on the inputs - as well as flag the inputs as not possible if the item has…
I am struggling with the beginning inventory formula. I feel confident with the later part of the formula but I don't see how I am going to rule out that it is the first week of the year. Should I add…
Hiya, I have 2 modules: Meldaliste Sales - 2 flat lists, time System_Product_Filter - 2 flat lists The flat lists in both modules are the same. I need to create a boolean formula in System_Product_Fil…
Hi, Can we have an another function similar to PREVIOUS so that it can bring the value of previous line item. Example: There are two Lists and three line items (Op Bal, Exp and Cl Bal) in columns. Pag…
Hi, I am trying to upload a ".csv" file into Anaplan using Postman. Below is the API used. PUT https://api.anaplan.com/2/0/workspaces/((workspace_id}}/models/{{model_id}}/files/{{file_id}} But it is t…
Hello, I am section 5.5 in L3 Sprint 2, where we are asked to - "In the Data Hub model, create an Employee Details system module. Then, download the Employee Details data file and import into the Data…
Hi, I am having trouble with the formula in the DAT02 PY Revenue to CY module. Steps I have performed thus far: 1. Pulled from the Historical Data in the Data Hub into the DAT01 module in the Sales Pl…
Hi All, I have a requirement to highlight rows with duplicate line items in a Module. I have tried using the ISFIRSTOCCURRENCE along with conditional formatting but was only able to highlight the 2nd …
Hi, I am looking for a way to automatically create a ragged hierarchy for all possible combinations. The input is a simple file with only the parent - child combinations. I've attached a screenshot of…
Adding filters/dropdowns to the modules panel would be a simple solution to help model builders locate modules. Something similar to the excel functionality would be perfect. I believe this solution w…
Hi Anaplanner, I have a scenario where the time period(year) should be selected from the dropdown for a line item. The model calendar holds 9 years and a time range holds 3 years. I require the dropdo…
I am facing difficulty in setting up time (months ) dimensioni.e to include only months in time dimension in REP02 size margin report .can anybody who has done this help me out on this
Hi, I am trying to import from a source module applying to a scenario list, to a target module that is independent of this list. Can I select which scenario to import from? I know that if it is the op…
Am I supposed to get so many exceptions? I looked at the suggested template, which only shows 1 here and there. Mine has loads. The instruction was this: I've summed it - and given the stock runs out …
Hello Gurus, We have an allocation problem. We have Shortages(Demand) and Supply by month. We have to allocate the oldest supply to the demand ie FIFO. Also, there is an expiry period for the supply, …
Hello All, I was wondering if it is possible to retrieve Workspace ID and Model IDs of any given Model which then can be pulled into a CSV file? Then imported into my current model? What I am looking …
Hi, Any tips as to hide HY/FY view UNLESS you have all 6/12 months - is this a simple formula in the time modules and then used in a filter? Would that be against best practice for having >1 filter fo…
Hi team! I was hoping to see the image in a grid support and the row height adjustment for word wrap in a grid. Does anyone know what actually got implemented yesterday, and did these two make it into…
Hi - I'm ready to take the Level 1 Model building exam. From the instructions it seems I should plan on completing in one session. I'm planning my week, how much time do you recommend setting aside to…
Hi, Current I have designed like this to select first week of the time scale. But I am wondering is there a way in ANAPLAN That If I select one check box for that Line ITEM, it will disable all other…
Hi, I have historic figures for volume in DAT03 for FY19 that have been offset to give me baseline forecast for FY20. How do I achieve the same for baseline forecast in FY21 as currently my baseline d…
Hi, I have an actuals module that has all transactional data from the actuals in local currency. In there I created a line item, Amount FX, that has a subsidiary view since it has the FX Rate dimensio…
Hello, We have an line item composed of all the Sales Reps associated with an account (some only have 1, some have multiple). This line item is text formatted. This line items is called "Sales Reps" W…
Hi, I am looking for a functionality about how can I automate or schedule a process with in Anaplan, which transfers data from one model to another model with out clicking manually each time on that p…
DEMO03 Baseline Forecast module showing zero's for FY21 I have used four more formula's along with the shown in this image. Formula 1 : IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' then OFFS…
Hi I have a module where the formula scope is currently showing "actual version", where if time is less than switchover or isactualversion(), then it picks up actuals. I've tried to drill down, but I …
Today, we need to update Start Time in DEV then do an ALM but it can be complicated if we have developments on going. We would like to be able to do it directly in our PROD Model. We would like also t…
