in Learning Activity Sprint 3, we asked to make a Distribution Center Summary UX Page and when I take the exam, there's a question that I wont be able to answer cause it doesn't match the values on th…
Hello Team, 1. We have a model where all the invoice amount is multiplied by six after the latest data is uploaded. 2. Also, I am not sure where the source data is coming from, which I need help with …
Hi I'm trying to get the last quarter of the FY formula. I have Q1FY22, Q2FY22, Q3FY22, Q4FY22. I need a boolean which checks the last quarter of the FY ie., Q4FY22. Please help.
Hi Everyone, I've been stuck the last few days working on User Story 1.4 & 1.5 | 5.2 Model Building Specifications. There isn't enough information for me to comprehend what is needed to be done and th…
We would like to seek assistance on how we can build a requirement where Anaplan needs to recommend the sequence and volume of products to produce in a line with consideration of line capacity and pri…
Greetings! One of the models in use by my company is the statistical forecasting model, whereby material history comes in through a calculations module and the material is assigned a forecasting metho…
Hello All, I have a requirement where my end users are doing some manual text based tagging(excel screenshot below). Within Anaplan, I maintained this mapping as a list with the tagged value as a prop…
Hi Colleagues, Master Anaplanners. I've recently bumped in some complex calculations where I had to use different logic for different levels of hierarchy, most I've achieved through Ratio summary meth…
Hello, Good day to you, all. I would like to ask this question that's been bugging me for days now. Situation: 1. I have a module that houses actual data primarily used for uploading a csv file. This …
The problem I get after I insert the formula is the its tell me formula is invalid because the line items is missing and i attach the instruction of what I was trying to accomplish.
Hey planners, I'm sure there is a logical way to go about this, but I'm stuck in a mind maze. I'm simply trying to dynamically select the following year in my time system module. Actual period is Jul …
I have two staging modules: 1) Account Master, and 2) Account Ledger What I am looking to do is populate accounts from the the account master where the accounts exist in the ledger. I don't want to po…
Hi, I'm sure I'm having a blond moment. What's the easiest way to achieve the equivalent of this Excel formula/situation (Column F), in Anaplan ? Thanks!
I have a calculation currently in the "Usage Base Forecast" line item. I want it so that if a user checks off the "Use Previous Month Final Forecast", it moves the final forecast from last month to ne…
Hi all, The use of the TEXTLIST() is not a best practice. However, as I go through the Anapedia, Planual and forum threads I haven't seen the alternative for that. There are some forum threads that pr…
Hello, I have a module that contains a bunch of servers, and for each server there is an asset tag. The asset tags are in sequential order. I was wondering if it was possible to display the year for e…
Hello All, I have an issue where in there is table 1 with below structure: List (category list)Line item1 Line item 2DifferenceA11257A2410-6B11020-10B2633Total3238-6 And there is a table 2, which is a…
Can I add drop down list (with data from a list) to cells that are loaded with data? I've added a validate button, but now I'm trying to create a functionality that allows managers to make changes to …
Hi, I have a scheduled import into a history module with a snapshot of data, every Friday at 2:00am. This all works. However, sometimes we need to take the snapshot manually earlier in the week, and i…
Hi everyone, I am replacing SELECT functions with LOOKUP as a part of model optimization (2.02-14 Avoid using SELECT). I did it lots of times and they worked but I am struggling with couple of them. M…
The above image show what has to be done I have attach the data i am getting for shipping cost is wrong I am not able to rectify please help me out what i have done wrong .
I have attached screenshot ,what booleans I must have checked in INV01 so that my module will be ready for further calaculatons or whatever changes I should made in this module to make it calculation …
Almost completed the work Just confused regarding my work plz suggest if I am wrong 1. Should I use "Submit Purchase Order Request" line item as formula in AD02 Inventory Ordering for Overrides "Submi…
When using the quick sum bar functionality (https://help.anaplan.com/anapedia/Content/Modeling/Navigate%20Anaplan/Quick%20Sum%20Bar.html?_ga=2.86794650.366156822.1550101511-1666663741.1546456255), you…
I am looking for a solution on how to write a formula that takes the value for 1 and Jan 21 and adds that value to the answer to the formula in cell 2 and Jan 21. The formula I have currently is the b…
