-
Working Days Calculation
Hi, I have been using the long formula for working days suggested in the Anaplan help, and it's been giving me some issues, so I created a new one It's shorter and easier to follow and thought I would share You need 5 fields* *Holidays is optional and can be removed example of calcs Hope it helps Kev
-
Dimension order within aggregation square brackets in a formula
Hello there, Out of curiosity, does the order of dimensions within square brackets (aggregation functions) have a significant impact on performance? Is it better if they follow the order in the "Applies To" section (and if so, where does Time fit into this) or does it not matter? e.g. Sales Volume = Quanitity Sold[SUM:…
-
Composite List Hierarchy not syncing to production
Hi Everyone, I am having an issue syncing a composite hierarchy from development to production. Below is the list hierarchy structure example:- GL1 Level1(structural list) GL2 Level2 (structural list) GL3 Level3 (numbered list) GL4 Level4 (numbered list) After syncing to PROD the lists items does not sync. Please does…
-
Anaplan Performance Issue
Hi All, I am facing issue in terms of Anaplan Model Performance. In my model I have a Filter Criteria Module which allows user to filter the dataset in a particular module based on the users selection. Dimensions in Filter criteria module is Z-User which allows me to provide selective access to the particular module. If I…
-
Hide one dimension in a column when there are 2 dimensions
Hi everyone, Anyone knows if it is possible to hide the time dimension without taking it out of a certain module? In this specific case I want hide the years (FY20 and FY21) but still have time as a dimension. My final objective is to have this table on a dashboard without the year indication on the columns. Just for…
-
Revision Tag: Roles -> Actions
Hello, I have a quick question in regards to revision tags. If I were check the box to grant a user access in "Roles → Actions" in DEV, would that require or qualify to use a Revision Tag in order for it to sync to PROD? Or what would be the best way to update the change, so it reflects in PROD?
-
How can we import data from one version to another version in a same module?
I have custom version list having Version 1 , Version 2 …. etc. I have a system module dimension with version list and fron there I am checking the Boolean "Copy From?" and "Copy To" based on the selection I want to import from version 1 to version 2 or vice versa. I have created the saved views but facing problem in…
-
Filter on the line with a module which have different dimension
Hi, In a module i have to filter a line with boolean line from another module but both modules have different dimension. in Target module we concatinate 3 attribute, but in source module(where the boolean is) we are using a list with only one attribute. Systen is unable to identify the line. need a formula for filtered…
-
Number of working days in a month
Excel uses the formula function NETWORKINGDAYS to calculate the number of working days in a month How would I do this in Anaplan? Link to an input module?
-
keeping last duplicate in numbered list
hi community, transactions is a numbered list and module has 3 line items, 2 are text and 1 is number formatted so the ask is to find duplicate combination of customer, prod and value in the list and in case of match , keep the last item and delete the first item here, 1 and 4 are duplicate , 3 and 6 are duplicate , but we…
-
How to get data from source module with time dimension to target module without time dimension
Dear Team, Hi again! I would like to inquire on how to get data from source module with time dimension to target module without time dimension. For illustrate further: Module 1 - Upload of Year to date balances - with time dimension (Month) Module 2- Deduct the current period(month) from previous period(month) to arrive at…
-
Finding the first working day of the month
Hi guys, I am trying to create a calendar. In this calendar I need to pull out the first working day after day X. For example : I have a module with holidays, working days etc. as booleans and on the other side I have 1st of january 2nd etc. Let's imagine the 1st of jan is a saturday. I would like then to check the 2nd of…
-
Compare numbers in different modules
Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…
-
FINDITEM on Numbered List Without Code
Is it possible to do a FINDITEM on a numbered list without using the code field? The numbered list restriction exists because I need non-admin end users to easily add to the list (e.g. by adding a 'Create' action). The code restriction exists because non-admin end users will be adding to the list, and hence will not be…
-
Setting a Date formatted line item to Blank
I am trying the following. Not sure if the issue is that the Date format items can´t be blank or something on my formula
-
How to reorder a list automatically?
Hello, How to reorder a list based on a property? I've got some lists that are very long. I'm only able to reorder them via the Order List action using their Display Name provided that the Display Name is a text format. What I've done so far is create a module and get the list's Display Name and sorted the module via the…
-
Cost Optimizer - LPP problem solving for supply chain optimizatino
Do wer have LPP optimizer in Anaplan in built.
-
How to fill a line item recursively
Hi! I have one module where one of the line items is my inventory amount and on the columns I have a list where I put diferent fiscal years (note that I cannot use the formula PREVIOUS() because this module is not connected with Time, and I can't connect it either). So my list is composed by: FY22, FY23, FY24, FY25, FY26,…
-
Calculation Help - Is there a function or a way to count number of child of a list member
Calculation Help - Is there a function or a way to count number of child of a list member For eg, if I have State - City Hiearchy How can I count how many city does a state have using a formula?
-
Sort my months descending
Hello all, I have a standard module that will show data by month. But I would like to Sort it starting from Mar 23 and go backwards. How can I make this happen? I was thinking of putting a Sort number in every single column with a date in it. I want it to flip in the screenshot below. Thanks!
-
Creating Fuzzy Matching functionality in Anaplan
Hi all Anaplanners, Does anyone have any insights in build the fuzzy matching functionality inside of Anaplan to identify the likelihood of duplicated strings ( company name, rep name, etc)? Alteryx have the fuzzy matching functionality and that's pretty much what I want to replicate inside Anaplan as well. Thanks, Jim
-
How to convert Month Line item in text format to Month Format
Hi All I have two month line items in text format as shown in picture and want to convert to Month formatted line item. What steps should I take so that I convert it into Month formatted line item. Thanks in advance
-
Preparing Data Exports - Shipping export module and Demond Export module Help needed
Hi I am having some issues with this portion of the level 2 conclusion activity. In the Supply Chain model, create a module to export the shipping costs by location and create a saved view for export: Module Name: INV05 Shipping Export Dimensions: G3 Locations list, Time (months) Category: Inventory Functional Area:…
-
Auto-Hide line item based on selected list member
Hi, Is there a way I can hide line item based on the selected list member? I tried to use line item subset but no luck since I have a date format and boolean in my line item. See attached picture. GLA, % of Sales and Sales Quota should be hidden when i select a different list member. Thanks, Tom
-
Import Sources
Hello Anaplan community, There are several notions related to import sources that I have trouble comprehending. These are : Source Labels, Source object, Source model (in Actions) and Source models. I can not understand what each term means, what is the difference between them, how should I manage the import sources in ALM…
-
Highlight Downward Trend
Hi Guys, I have a question. I am looking at the yearly data by GL levels and want to highlight the GLs that are trending downwards YoY compared to my base year. Is there an easy way to do it? Thanks, Megha
-
Anaplan Optimizer - minimize products used
Hi Optimization Pros! Would you be open to providing some input on whether this can be done in Anaplan Optimizer? I want to minimize the number of SKUs picked for shipment (i.e. we would prefer to fill a shipment by picking one SKU rather than two SKUs). These are the two designs I’ve tried with no luck. Variable: SKU Qty…
-
Import filter by user
Hello, We are updating a spoke model from our data hub daily, and I need to enable end users to individually update the spoke model for their specific list member (property) only. Currently, imports from the data hub are running daily into staging modules. Now I need a way to allow different users to run a process to…
-
How to change date format during a module export.
During a module export I want to change the date format into a fixed format instead. Currently, the date format is exported as per the system's date/time settings. Is there a way where I can change the date format so that it remains the same across regions in the csv export.
-
Add the current user to a field when they approve an item
I have an approval process with several gates, i have restricted to ability to approve, but all i want to do is when the approve button is pressed is apply the current user details to the Approver and add Todays date. The date part is done, as I already have the date automatically updating in all models. How can i get the…