trying to figure out what each element in CODE(ITEM('E2 Employees#')) does - i have read the documentation https://help.anaplan.com/41298b7a-e877-40e8-8cfa-8d7009d8686f-ITEM and https://help.anaplan.c…
Architect, Builders; Having worked projects with hundreds of bugs, the natural question is how did this happen? The solution passes User Acceptance Testing means that it was adequately tested. This co…
Hi, I currently have two different Data Sources in my Model (D01 & D02). They both share a MID and a CID that can link the data together. I need to be able to look up my data in my D02 Module by a Lis…
Hi All, Is there anyway by which formula's can be directly imported in a module for a line item? The blueprint view import option does allow to import a new line with a parent and a code from a file o…
I'm creating dashboards for budget owners at my firm. In the dashboard I have a variance analysis module showing budget vs actual. If one of my page selectors is the department (Dev, Sales, G&A) and i…
I'm looking to build a formula that would show the current YTD actual expenses, + the remaining year forecasted expenses to arrive to my FY total expenses. The current model we have set up adds togeth…
Hello Anaplan Community, During my Level-I and Level-II trainings I thought that it would be useful if an explanation with an detailed simulation for use of LOOKUP and SUM functions. There for I prepa…
As Model Builder, I want to have additional choice - TEXTLIST - when selecting summary for line items formatted as Text. When TEXTLIST is selected, summary should join/concatenate lower level data. Pr…
Hi, I am looking for a way to count the number of TRUE items for a Boolean formatted line item. As per above image, since 3 of the Booleans are selected, I need a mechanism where I can get 3 as the ou…
It would be very helpful to include a regex style formula in Anaplan so we can pre-process text fields ahead of an integration, or even help to cleanse messy inbound text. Currently if we want to remo…
Timesum formula currently works with time periods. When the granularity of the data is Days, the formula cannot return anything (although it does not generate an error). The idea here is to enable Tim…
In the Inventory Ordering Module, I'm trying to use the below formula for Shipping Method:- 'SYS07 Distribution Center Details'.Default Shipping(LOOKUP : 'SYS08 SKU Details'.Supplied By)But I'm gettin…
To illustrate Module A in Model #1 has a weekly time dimension My goal is to take the highest weekly MTA number of a given month and bring it to a new Model that's dimensioned by months and use the MA…
I would like to see the possibility to disable formulas for an entire Version. This would enable to save a bulk copy of latest forecast without regards to change in logic. Currently this is managed by…
Description of the enhancement required: Improve conditional formatting by allowing formulas. An example of the enhancement: Have it function similar to excel where formulas can be used to test for co…
I want to create dependant dropdown for Accounts (Dependent on Country and Segment) to complete the user story 2.5 Level 3. However I am able to select only one either country or segment. How can I cr…
Hi community members, can someone please take a look at my formula for 3 3 5 6 Update Inventory Ordering to Calculate Shipping Costs - Shipping costs line item Here's the formula hint provided in the …
I think it would be very useful to have a function to return the number of leaf items present in a standard or numbered list. Example: QUANTITY(x) Where 'x' is the name of the list, also selectable fr…
How close am i here??? The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role …
I have a text formatted line item called Company Code = "0505" When I export the module, I noticed that the Company Code becomes 505 instead of 0505. Why was the leading zero removed when I exported i…
Hi, There are lists (Department and Employee where the Department is the parent of Employee). I want to make a UX page where the user can select the employee and change his department, therefore detai…
I have done all formulas and checked my work against the course examples and everything was good until I review the Nutzo Bar_En selecting the Submit Purchase Order Request? I get the following: The e…
i hope this message finds you well i would really like to have your insight and troubleshooting skills on the issue i am having with the inventory ordering module the following are the line items and …
In my situation here, I have a source module that has two dimensions - EMP and Geo and Time and line item called MAP which is list formatted (GEO). Target dimension has one dimension EMP and Time and …
Many of our users would find it helpful if when filtering on text formatted line items, there was the option to use 'Does Not Contain'. There is a 'Contains' condition, which has proved helpful, howev…
Hey, When creating the DEM02 Volume Growth Rates by Week module, the activity wants you to "Write a formula to pull Volume Growth Rates value (in months) from DEM01 module and convert to weekly value"…
The current button we have in place has us add in a new SUB-GL/ vendor item to a numbered list. That numbered list uses an OpEx subset that layers in each new vendor into its respective opex area such…
Hi community! I couldn't find any information on whether it's recommended to split SELECT and LOOKUP for better performance. This thread helped me to understand that SELECT works in a similar way as L…
