-
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.
-
Import from module with greater dimensionality
Hi, I'm attempting to import data from a module in another Model (monthly employment costs per employee) which has greater dimensionality than my current module (The source has a Currency List & also Versions which the current Model does not have) Is there a way to SELECT a Currency List & Version item to import or do you…
-
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…
-
How do I sum across dimensions other than time?
Hello Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. 0x80070490 Beyond allocation use, is there a way to introduce a line item that returns the value at the next…
-
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…
-
Extend Date format to include Time (hh-mm-ss)
Description: Being an Anaplan Builder, I would like to be able to have a date format with Time in it (hh-mm-hh) Some of our planning tasks are connected with work with exact timing (Date + Time). Currently, we have to upload this data as text and use RIGHT(),MID(),LEFT() functions to extract values. If we have a customized…
-
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…
-
cell security change for model builder
Hi All, The cell security is a great feature, but I find it a bit confusing that as a model builder you are able to upload data where a normal contributor is not able to upload data. This makes it more difficult to test solutions, because the model will behave differently if you are a model builder versus when you are a…
-
Applies To for a module - would be nice to have a search option
Description of the enhancement required: Creating Modules or adjusting the "Applies To" it would be helpful to have a search bar/button. A story for why they want the enhancement, (how would it help their business process): In case you have a lot of lists, it becomes very inconvenient to reapply the module. This change…
-
Display the Action IDs in Actions list
Description of the enhancement required: Display the Action's IDs in Actions list so that Interface (Anaplan Connect or Rest API) can work with action's IDs (not with captions (Action Names)) A story for why they want the enhancement, (how would it help their business process): At the moment, to refer an action by ID we…
-
Increase the limit of characters in Notes section
HI Team, It would be really helpful, if we can increase the limit of characters in Notes section of a module. Currently it has 250 as a limit. I got stuck here when I tried to copy paste one lengthy formula cos I don't want delete the formula instead I might take that for my future reference. Let me know others thoughts on…
-
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?
-
Edit Dashboard
Dear Members, I am getting a Slider which I want to remove. Desired Format has no Slider. Please help me to remove the slider from Dashboard. Thanks.
-
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…
-
Dashboard Header Module
Dear Members, Require your help in removing the Module Name from Dashboard. I have shared the Desired Format (How I want) and My Format (How I have). Please feel free to ask in any difficulty of understanding.
-
Create Child in Numbered List
I had the original Model, and I was trying to replicate it. The pic 01 and 02 are the Original ones. The pic 03, 04, 05, 06 are my Model. It is restricting me to enter the values:- Soft Drinks, Tea.... I even tried creating .txt file and import it but it failed too. I need your kind help for this. Please feel free to ask…
-
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…
-
Ability to sort the order of views on a module using Ascending or descending options
Currently when you click Manage Views on a Module you can move a view up or down to change its order. It would be easier if we could have the option to sort in the same way for other objects with an ascending and descending order option or a top or bottom option. In addition you can only move a view once in either an up or…
-
Import period format to Time Periods or Date formatted line items
As we drive to remove Text from our models, dealing with Dates is troublesome. When mapping files to Time Periods in modules, we can choose periods and define the format. For example, in my file I have YYYYMM. However, when I am trying to bring this data into a formatted list I do not have this choice. Even when formatting…