hi guys, i would like to know how i can do this in anaplan ( image). i have a module dimensionned by one list. the module is published in the new ux as a worksheet filled by the end users using a form…
Please help. I am Missing data in the forecast version of the REP03 module and cannot figure this out. I feel like I've checked everything three times, and don't know why the data isn't populating.
Hello all, My team is working on breaking apart a particularly complicated SUM/LOOKUP formula that was built 4 years ago. Looking for guidance anyone may have out there. Here's what the scenario is: -…
Hello, I am struggling to figure out how to distinguish the usage between SUM function and LOOKUP function. Could anyone explain the meaning of the "list-formatted" such as list-formatted line item/pr…
For some reason I can't figure out the formula set up for questions 3 & 4 bonus and phone costs by role. I am wondering if my references are mismatched. Any help on this is appreciated as I feel like …
In order to support varied testing and especially split-model deployments (same dev model with different data sets/time periods), it would be useful to have Time Ranges be Production Data. This will p…
Hi all, First time posting to Anaplan community, I'm hoping this is a task that can be automated by Anaplan, just another one of those time-saving features that would be perfect to be built into a mod…
I searched for the posts regarding zeroes vs null values but don't think I found an answer to my question. So in module A, when people create projects they input values. These values are brought to mo…
Is there a function to change a list value to a text? I want to use the & operator with list values, but it only accepts text. When I try just using the list-formatted line items, I get the error belo…
I can't seem to find any documentation on where the standard Category values for Module Functional Area and List are defined. Is it possible to modify the options here? Does Tenant Administration have…
Hello I need to solve a Supply Chain distribution planning problem through optimizer. I am solving for a small network of warehouses & depots, you can refer the same in the attachment provided. Follow…
Hello I´m trying to use to Booleans to give read and write access in one of my models but one is at a quarter level and the other is at yearly level. I want the Boolean to be checked by default and ch…
Hey Guys, I finished entering my formulas without an error but i got the wrong answer... does the format in which i type the answer matter, for example xxxxx vs xx,xxx. I also don't know if my formula…
Hi, Can somebody help, I don't understand why the margin% is giving me this number. It seems to be alright in most of the other columns but for whatever reason some are not working properly. Thanks in…
Hi All, I am reviewing a model where formula scope has been assigned to a line item which is NOT dimensioned by versions. The line item also contains a formula. The line item can be manually edited wh…
Hi, I want to import "order" file to modules. I have several modules which has Item number List as Applies To. module A & B. I want to import this type of csv file. This order files don't have order n…
Hello, Is "zero padding" possible in formula of Anaplan? What I'd like to do is, for example, changing "123" to "00123" or "1234" to "01234" if a number has to be held as five digits. In other words, …
Hi guys, could someone tell me how i can possibly do this in anaplan? i have a module dimensioned by a list, a list of compagnies(A,B,C). this module is published in the new ux as a worksheet and im u…
Hi! I'm stuck on this activity. I believe my current period settings may be wrong? As my model isn't matching with the screenshot through check your work:
I am confused about the adding DCA into Inventory. Do I need to create formula in AD02 module or Should I create an Add a Read line items also. Can somebody explain me Step by step what to do here ??…
Hi, I am building a small optimization model, I am getting "Constraint does not exist" error message. I am not able to identify why I am getting this error. can anyone please help? Thanks, Sourabh
Hi, I need a formula that can give me the actual Last day of the current month. As the current month is October'21, I want to get the result as 10/31/2021. Can someone help me with the formula or guid…
I have an aggregates sales forecast module that only has time dimension. The sales line item in the aggregation module is doing a lookup at sales metrics module that has stores and scenarios as a dime…
Hi, I am having trouble importing the Data - file Employees.csv - for SYS08 Employee Details module. The data is not looking like it should and I have tried to map it multiple ways. It is a numbered l…
Hello I have been stuck on this activity for days now, I had searched the community for similar issues but could not find any, my mapping on G3 and P2 doesn't automatically map and it causes an error,…
Hi Friends, is there any formula / straight way to know the month number of the Current Fiscal Year? e.g. if the CURRENT FISCAL YEAR in Time Setting is as below Then Apr'2021 is first month of FY22. H…
September 2021 Release and Sneak Peek at October 1. Pasting into Breakback Cells: Within UX, now it’s possible to easily paste values into Breakback enabled cells which are highlighted by blue markers…
Hi Team, We are facing issues while opening my existing Models in my workspace, last 3 hours back i was able to access my Models but now i'm unable to access. Could someone please help me here. We are…
