Hi All having completed the 102 course I am in the process of building my first model, so please be gentle if I have asked a ridiculious question but I really cant figure this out. I have a line item …
Dear Members, I am new to Anaplan, so I would request your generous help. Order Number or Transaction Number is a Line Item or List Item? And if the answer is List. Then let me know, if millions of tr…
Hi, I'm wondering is someone could help us with the following: We have a transaction module called "Data Store" which is made up of line items (columns) and a Transaction Unique Key (List - Rows) Refe…
Hi, I am doing an OpEx forecast. How do I write a forumula to get the average of the past 3 month from the same line item for the Forecast Version only? I also want to be able to override the amount m…
Currently you're only able to use systm properties: Name and Code to identify List elements. Please add an optional argument in a FIND functions that would allow to use any single exact property in th…
ITEM is not an occupied system property while CODE is. This makes the formulas ITEM and CODE not equivalent and thus inconsistent for Anaplan modelers. Since CODE() and ITEM() are very similar formula…
Please add an option to use LOOKUP function towards a line item that has less dimensions. For example: I have a line item that has three dimensions: * Client * SKU * Month I try to get some masterdata…
Description of the enhancement requiredCould you please add to the enhancement list the task to add a new standard subtotal for timescale?We are very interested to have BOHY showing the YTG numbers fo…
Hi, At present within Anaplan it is possible to dynamically change the contents of a Display Name (on a numbered list) and to give the end user the ability to change the Display Name (or its alias) as…
Hi, I need to be able to create a DB that allows me to choose what currency to display. At the moment I have data in various currencies, a currency conversion module has been made which hosts GBP, Loc…
Hi, I need to be able to show actual data and forecast in same line item. I have an actuals line item, forecast line item, then total view line item. Formula i have written is IF Time filter.Actual Mo…
Currently we have a formula that is returning the last week of the month from the look up. How do I get the look up to do a sum of all weeks within the month ? CURRENTVERSION()'.h_collect previous ver…
Hi, I have a line item in this module called "TPS System Takeout" and in the column next to it "TPS Competitor Report Type Classification" i want it to find the matching name in this list "CTO Competi…
Doing an OpEx forecast. I have the usual OpEx Account list and Department list along with vendor list. However, on the module, I want to show vendors under the GL. When I do this, it shows all the ven…
I performed an incremental load / full load of the master data(lists) from my Data Hub to a Spoke Model. Now, in my data hub, I renamed a list item in one of my lists and I want to update the same in …
Hi everyone, I created the chrome extension Anaplan Formulator to make long formulas easier to read in the native formula editor. The extension inserts a return before and after each IF, THEN, and ELS…
Ability to select a level of the hierarchy to show and have synchronization based on selection. Ability to have separate tables built out for a hierarchy to drill down into without creating separate m…
Currently the aggregation functions only work towards list data type. This disallows to fully replace VLOOKUP function in Excel. Please add at least some additional functionality: for example to searc…
There is currently no way I can use TEXTLIST function with both unique values AND mapping. * Either you can use parenthesis function with UNIQUE property * Or aggregation function with mapping but wit…
Hi, I think this should be an easy solution, and maybe i am trying too hard Consider the module below, data coming from a list start date, end date, and a count (1 = yes, 0 = no) I want to populate Pr…
I would like the ability to add an Concatenate to Select Function. For example SELECT: VERSIONS."Budget "&NAME(Current Year). As we have multiple Budget Version, the current version in play and the fu…
Hi everyone I need some help with a formula. I want to create a line item (LINE ITEM B) to check that another line item (LINE ITEM A) only has an entry in one period. The line item that I want to do t…
Hi Experts, I am using two line items, Both line items are text format. Line item 1: FCST_1 Line item 2: FCST_2 For suppose FCST_1= 5.4591 Then By using FCST_1 we need to calculate FCST_2= 5,46(Rounde…
Is it possible to get the running balance of a numbered list? my numbered list is a daily cash transactio and i need a line item taht will get the running balance per transaction. Thanks!
