I have a list of 'n' items and I run an import action on the list. The numbers of items in the list is now 'm'. How can I identify the items that were inserted in the current import. The import file c…
Hello Anaplan Community, I want to import the same list from a model 1 to model B but I have this message that pops up every time. Can you tell me the reason behind this ? Thanks in advance !
Hi all, Ran into an issue when I opened up a future year in my model. For some reason the the module in the picture below will not populate data for the new year (2025). I've racked my brain quite a b…
Looking for a way to sum off a data module based on dynamic user selections. My dashboard has a filter(dimensioned by user). Users select any combination of these dimensions(except amount and account)…
Hello I'm having issues to import the data into Employees list. Instead of showing the employees names its showing a number with # in front of it. Could you please help me?
I am trying to get a row of data to be automatically uploaded to a row that has not been filled yet. (I currently have it set up where you have to manually select the row every import) Also is it poss…
I am trying to sum the revenue data in the "PY Account and Product Revenue" line item by account. Source and target module are both dimensioned by the same account>product combo list. I keep getting t…
Hi All, I am really struggling to bring values in the Length of Service line item. Since the module is not big I had first tried to manually select items from drop down for all Reps but I realized tha…
Is it possible to build a module with no dimensions that will allow us to import a file with thousands of rows? The current file we receive does not have a unique code. We would like to import this fi…
Hey, I am trying to make a boolean filter so you only see the columns with data plus x number of empty columns. So I have the Boolean Has Data? that is true if any line item has data. So, what I want …
I have a requirement where in i have to exclude the year 2020 while calculating the cy projection sales for 2024. Hence when i calculate, i choose a last 5 year period (2019-2023). However in this las…
Hi I would like to have a filter for native versions (i.e Current Forecast and Budget versions only) for an import view. I have set up a version system module where I can tick the boolean against the …
Originally we had A1 Expense Group, A2 Expense Category, and A3 Expense Account. We added A3 Subcategory and changed the naming of A3 Expense Account to A4 Expense Account. We have been unable to chan…
I'm trying to add a column to an existing module in Anaplan, but I can't seem to find the option to do so. The only modifications I can make are to the lists, time scale, and version of the module. Ho…
Hi All, [Select: Time. All Periods] works for Model calendar and Time ranges? Somehow, its working for Model Calendar but not for Time Ranges. Do we have any similar function for Time Ranges? Thanks A…
Hi all , I am trying to make model not to (re)calculate in some scenarios a variable and (re)calculate only when a boolean is ticked . I did some performance scenarios analysis of calculations (counti…
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I …
I am trying to pulling billings from a calc modules, the source and target modules are both dimensioned by country but I keep getting this error. Note: I am trying to pull in billings from CALC02 whic…
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…
