I'm trying to optimize a module for space. At current the module alone occupies 33 GB of space. The module is a cross dimension of 4 lists as seen in the picture above. with time month granularity. Th…
I have a module called Project. It has line item called "Project name". Project name line item contains only those projects which are approved (used formula to get these) My question is can we create …
Hello everyone, I’m stuck because the column 'Default Shipping' in the Supply Chain Model is not populated after I run the import from SYS07 Location Details —> Import Distribution Center Details save…
Hello everyone, I'm stuck at this point. I entered all the formulas for the line items in the module but as you can see the shipping costs line item is zero value. Also in INV01 Module the shipping co…
I'm sure I've used the "PREVIOUS" function before without any problems but on trying to use recently it doesn't now seem to be returning the values I would expect As you can see the formula Previous(V…
Hi All Community Members, Despite putting a lot of thought and efforts, I am not able to figure out where am I going wrong. I have set all the Modules and formulae in place but still the numbers for t…
Hi All Have a super-user who is Full Access as model role but not a Workspace Admin and so therefore should be able to run updates to list subsets. Is there something in the depths of Anapedia that sa…
I am trying to load a csv file containing above properties in to a numbered list. and it throws me an error saying name cannot be named, but in the above case i didnt map the Name, I just mapped the p…
I have two list: Target Center and Table Type: When a user selects target center I would like only the centers that are in the table type that is selected. For example if table type "FTE" is selected …
Hi, Below we have 3 line items in a same module, I want to apply DCA in such a way, If I select Country, Sub-region and Region should disable If I select Sub-region, and Country and Region should disa…
I would like to sum a line item based upon another line item that is not a list. So for example, I have the following: In this case, bananas is able to be listed twice because it is under different pa…
I have a list with employee names all in upper case. E.g. DANIEL SMITH How can I convert these names in Anaplan to Daniel Smith (upper case on the first letter then lower case for the remaining)
Hello, I am looking to get a YTD calc but I cannot use the YEARTODATE function because I need an average, not a SUM. And previous years should calculate according to their months (i.e. I would see a f…
So i have a nested if statement that checks the status of a shipment. "cancelled" or "storage" first using boolean, the progresses through a series of dates to see which have been added, finally defau…
Hey, there I'm new to Anaplan and I'm exploring how to smoothly execute a matrix product within it. I have two modules: one resembling a (1,5) matrix and the other a (5,5) matrix. My goal is to perfor…
Hello, I have a table and a graph based on a table. The selection that I have in Years, Quarters and Month. The Table should move on every selection of Year, Quarter or Month but the Graph I just want…
Hi All, I have a request by a customer to have version to version variance analysis done where, when a version is selected from a drop down for comparison the version name selected appears on the colu…
Hi, I am having issues using the optimizer for production allocation. The model is for capacity planning. Problem statement Need to allocate the SKU demand to compatible factory lines based on the fol…
I have created model for currency conversion, all went well but at last after I add the formulas its not showing any data. Not sure where I am going wrong.
Hello all, I'm encountering an issue where selective access filters don't seem to be applied to a list (numbered) when it's being used as a column (select list) in my Anaplan model. The selective acce…
