-
How to Count the recurring combinations of List Members
I want to Count the recurring combinations of Time, Employee, Project and Fund but the issue is that the List is too big to use Sum function, I need some other means as I cannot even create a TRID for it due to lot of List Members and also I am unable to create a Staging Module or anything like that to do the task. I want…
-
How to Select the Current Fiscal Year
Hello, I have a data module that lands data in a monthly basis. I then created a module that has Q1 to Q4 line items - the intention is to get the data from Mar 23 for Q1, Jun 23 for Q2, etc. So I then created a module with the below line items and with the year as my time dimension and put a formula in each of them so the…
-
vLOOK Error "'REV04 Price Growth Rates'.Unit Price % is not a recognized line item or list member"
Hello, i am getting error message "'REV04 Price Growth Rates'.Unit Price % is not a recognized line item or list member" when i am trying to apply vlook formula. https://us.v-cdn.net/6037036/uploads/S4OLDCCZ2ZF7/error-message.docx
-
how to decide the completed years(Length of service)
hi guys~ In Sales_Rep_Details module, What we know is the sale start date, so I calculate the completed years by: Start_Date_Current_Period(2020-01-01) - Start Date then I devide it by 356 the final formula is ROUND(('SYS01 Time Settings by Month'.Start_Date_Current_Period - Start Date) / 365, 0, Up,NORMAL) by compare my…
-
What is the process for viewing a workspace map like a model map in Anaplan?
Hello, I'm attempting to figure out how to examine workspace maps, similar to Model maps. It will be useful for us to keep track of the dataflow between models. Is there anything we have for Anaplan? TIA
-
Displaying an Incorrect Version of Data
Hi All, I just would like to check if anyone experienced the issue wherein affected users are viewing an incorrect data (ie. Actual was selected as version on context selector however, the report in Apps shows Budget data). I tried to replicate the issue by giving the same role permission on my account as affected users…
-
Forecast and annual plan in parallel working in a single model
My forecast periods ends 4 weeks before the annual planning number submission. I need to find a way to use the model simultaneously for forecasting and annual planning. Is it possible to achieve? The model is also interconnected with other models. Can time and or version dimension be the solution?
-
Select Data using a Boolean from a module with other dimensions
Hello, I have the three following modules: Pick Year: Dimensions: Product, Forecast, Time (Year) Line Item: Select (Boolean) Employee Sales: Dimensions: Employee, Market, Time (Year) Line Item: Sales (Number) - Filled with a flat Sales module (Flat Sales Module.Sales Amount[sum: Employee, sum: Market, sum: Year]…
-
Importing file that has one column whose first row is empty
Hello everyone, I'm struggling with the import of a file: there is one column that has the first row empty, therefore the file won't upload properly. I can't remove the column from the combination of properties because I need it to generate the unique key. The only solution I've found so far is importing the file with…
-
Trigger mail to end user
Hi All, Greetings! I have a request from one of the user if I can trigger an export of dashboard to email ID at a particular time slot. I am assuming this can be achieved through integration only. But I would be glad to know if there are other ways to achieve it. Thank you, Harshitha N.
-
Is there a way to Sum from TIMESUMmed amount?
Hello, I have a module that is getting the data via a TIMESUM formula. It's causing an issue since it was not summed up by the dimension. So I'm changing the formula and trying to include a SUM string but it's returning an error: An expression or constant may not be used as argument 1 of the function TIMESUM.…
-
Find if List member exists in List formatted Line Item
Hello, I'm struggling with this problem: I have a module named "Example" using two dimensions: "Dummy" and "Test". It contains a line item called "Item" which is formatted as "Product", Product being a list. I would like to create a subset of only the products that have been used in this module but cannot find a way to…
-
Allocate a summary level data input into other
Hello, In one module, I want users to enter one growth number for a country. I then want that growth number to be applied to every single product in that country (in another module). There are thousands of products in the country, so I don't really want to have to enter the same growth number multiple times. However, I…
-
Avoid drill down to sensitive data
Hi folks, I have a challenge in a Workforce Planning model I am building. I have a organisational hierarchy going från A1→A6, where A6 being individual employees, and A4 being Cost Center. The selective access for the model is on Cost Centers (A4), which then gives access to Teams (A5) within the cost center and all…
-
1.4.3.2 Import Data & Add Formula
Hello, What formula should I use for the code line item? Instructions did not specifically describe the code. Thank you in advance!
-
Module Naming Conventions
Is there any article on best practices for module naming conventions in Anaplan? If yes, please could you share the link for the same. Thank you! :)
-
Writing information back to a blank module
Hello, I have an idea that I'm hoping can be done. I can't think of a way to do this now. I have a module at a Job level. I would like to write all the details of a particular job (Name, Code, location, salary) into a blank module that is not dimensioned by Job. I need this because I want to track a history of requests…
-
Using Users Dimensioned Line Item in a Formula With No Users Dimension
Hello, I have L1 and L2 lists, and recently I added a new flat list as A, and A is actually acting like parent of L1 that determines the groups L1 list members belong to. Since I do not want to mess the existing hierarchy and model functionalities, I prefered adding A as a flat list. In an L2 system module, I have an L2…
-
Is there a way to send context through a MAILTO function?
Hello, Has anyone found a way to send a MAILTO email with specific conext filters? For example, I would like to send a request to my dept manager. I have a MAILTO setup that will send to the right person based on the dept we're in now. This is setup in the Dept Properties module. But I would like the Request ID (numbered…
-
Scenario Planning
Hi Team, I have an unique issue which requries a uinque.. Lets say I have a List called - "Scenarios" -Scenario1 -Scenario2 -Scenario3 Using the list in a module called "Data Scenario" I want to copy data of Net Sales from Scenario 1 to Scenario 3, I know I can use the import action, however in that case, I will have to…