-
Get Value of Top Level
I have three lists: Product Lines L1, Product Category L2, Products L3. Total Products is the top level of Product Lines L1. I'm trying to calculate the product mix of each product in Products L3 as a percentage of Total Products. The module.line item that has the volume is Sales.Units Sold. But my question isn't about the…
-
File Load to List via process
Hi, I have loaded few Lists hierarchy from a file .txt and list was updated. used a process and included these actions, but when I run the process system is not allowing me to browse and choose the source file. So, If my source file data changes ,this process execution will not help me as it picks the old file everytime?…
-
Loading parent/child DRM file to Anaplan
Hi All, I have a source file with Parent/Child and node Levels, total 7 levels max. I want it to Load it to Anaplan list(7 different list) at different list levels. we are creating 7 different load files to load at different levels in the list, is there any other way to eliminate the 7 load(1 process) and do this in one…
-
Insert text into summaries
Hi, I've got a simple list (with codes) with summaries at different levels. I've got a module that applies this list I've got XL file where I have codes(from the list above) and text (1 to 1) How do I insert text from the file into the module into the summaries in my list? Thanks
-
Revenue and Expense eliminations in reports
I am creating a Income Statement where I would like to see a column for eliminating intercompany activity. Has anyone built a report or module that handles eliminating accounts?
-
How to reduce the dropdown list of a column
I have graders name as a column in a module. The column datatype is a list (graders name) I want to reduce the dropdown from that column to only active graders ---- I tried creating a subset of the list (graders name) and then using that list as a datatype in the column but that erases all the data related to previous…
-
filtering
Hi, Please see details on the attachment. Regards,
-
Edition Compatibility between SQL Server 2012 “Evaluation” Edition and “Enterprise” Edition
Hi all, I'm Newbie to SQL Server 2012, I found out that there are paid and free editions of SQL Server 2012 available . those are 1.Enterprise [paid] Tableau 10.4 B.I [paid ] 3. Standard [paid] 4. WEB [paid] 5. Express [free] 6. Evaluation [free] 7. Developer [free,paid] Now I have ambiguity between paid version and…
-
Incremental Load
Hi, How incremental load works from data source to data hub ?
-
Sum by Account starting with specific number
Hi, I have a List with accounts starting from 4* ,5* and 6*. These accounts have some data value against them,I want to Sum up the data value by 4* ,5* and 6*. Regards Madhu
-
Unicode References
HI Folks, Can we use Unicode Characters in Anaplan? As of my knowledge, we shouldn't use as it might reduce the performance of the model. Is that true? (I have access to One APP which itself built by Anaplan and I can see Unicode characters over there) If we can use it, can someone give or suggest the source where to get…
-
Pricing of Products with semi finished goods
Hi, How pricing of products for one plant can be used as semi finished goods for other plant with updated cost of product as raw material cost for the next plant. Please provide with the solution for designing the same. Thanks Pujitha
-
FINDITEM formula
Hi Can we use time rang for finding time period while using finditem function. Thanks & Regards Keerthi
-
Update Codes in a numbered list
Hi, I've set up a numbered list with an name property. The formula comes from a module - it should update the numbered list as well - any idea what I'm missing. Thanks.
-
Anaplan history not updated correctly
Hi Experts, We are using the Anaplan model from the last 3months. Now, when I check the history I am not able to see any history of the model. Is there any setting for showing history in Anaplan ?? Please help me with this. Regards, Uma
-
Import data to a module - have code info in file but List has code description
Hi, I want to import data into module which has Account list, where Account list has code-description format Example '1000004 - ABC' My Source file has account code only with balance. i,e Account Balance 1000004 200$ while importing source file unable to map account code with account full name in list. Note: This is not a…
-
Fiscal Calendar Lookup
I am trying to lookup (using the lookup formula) the fiscal year, fiscal quarter, fiscal period and fiscal week using the date an item was sold. We have a calendar module that contains all of the conversions (date, FYear, FQuarter, FPeriod, and FWeek). Sales are tracked using Fiscal Week End Date so my formula for fiscal…
-
Month to Date Formula
Hello, I'm trying to use month to date formula. It doesn't look like it's working correctly. cumulative amount should never decrease if i'm adding values month on month. Thanks
-
Is it possible to override a formula in a line item? If not, how can I enter a starting amount?
I want to be able to enter a starting amount and from there on have a formula driven on the line item. Example. Beginning ARR manual enter amount in Apr, then it will drive the calculation to get the ending ARR. The beginning ARR will equal to previous months Ending ARR. I included several screenshot. The excel file…
-
Project Planning v.1.2.3
Hoping to see if anyone has created a simple project plan . Task/Start/End/Owner/% complete in the Project Planning Model. When I start the process I get the below error. The list specified as the page selector is empty so there are no items to select. Ask your workspace administrator to add items to the list or remove it…
-
Weekvalue formula
Hello, I'm trying to pull weekly data into a module that is based on months. I've tried to use the WEEKVALUE formula, it returns 0. My source data has a week value assigned to it. Thanks Hina
-
Exclude Zeros From Average
I am calculating an average but I do not want the zero values to be included in the average. How can I exclude them?
-
Dynamic Display based on Time Period Type
Purpose: Retain views with multiple types of time scales/periods in the same view during YoY rollover, for multiple line items or list items, in a single view. Example: Dimensionality: Vertical/Columns- Time/ Line Item Horizontal/Rows- List Members Display: Line item 1 - Year only Line item 2 - Non-applicable (Display Full…
-
Disable endusers to change name of list items
Hello everyone, With several models up and running, we have encounterd the problem that some overenthusiastic collegues double or trippleclick the name of listitems that are presented on dashboards. This will allow them to change te name of the selected listitem. Is there any option to disable this function? The model…
-
Using Lists in IF formula
I'm trying to create a formula to say IF 'countries-filter'.'1' LOOKUP[Countries.'UK & ROI' ] THEN 'Actual (Current View)' - 'Forecast (Current View)' ELSE 'Actual (Current View)' - 'Forecast (Previous View)'. My countries are a list, so i created a Boolean module. 1 - UK 2 - IT 3 -DE I don't think i've set this…
-
Delta Load
Scenario: I changed the parent of a child then how to do incremental load when there is a change in parent child hierarchy?
-
Fp&A case study access (299)
Fp&A case study access 299Could you enable my access to FP&A Case Study please. I have completed courses 100, 101, and completed certification for 102, 201 Saurabh Sharma saurabhsharma08@hotmail.com saurabh.sharma@acgindia.co.in
-
Delta Load
How to do incremental load when there is change in any one of the list properties?
-
How do I get the data from a line item of a list in a module into another module?
I have two module. One call assumption, another. call Implied new room. I want to get the data from the line item call mix which is base on my subscription list from the assumption module . In my Implied new room module, I have 3 line item with the same name as my subscription list. I don't want to use a list because I…
-
Text function; Automatical conversion to scientific notation
Hy everyone! I'm encountering a problem with converting my values to text with the TEXT() function. My problem: When the value is 10,000,000 and I use the text() function, there is no problem. The text line item will show "10.000.000". When the value is 10,000,000.15 (with 2 decimals <> 0), The text line item wil show…