Modeling

IRR & NPV Calculations with Initial/Start Date
Hi All, I have tried a workaround for IRR, NPV calculations with initial Date i.e. similar to excel in Anaplan. It worked for me and Hoping that it will be helpful for others too I hope below Screenshots are in-detail to understand the logic.
Open Saved View from Open Source Module (NUX)
The functionality to Open Source Module in the New UX currently takes me to the main page of the model. Would be great if that functionality opened the model as well as the module & saved view that was published to the Worksheet or Dashboard for ease of page builders to make updates in saved views. It is not super easy to…
Drop-down list showing only Write-access list members
My client uses the Organization structure as the secured dimension in the model I am working in (Business Unit / Cost Pool / Cost Center) with Business Unit secured. They have multiple modules (pre-existing model in which I am making major modifications) that contain these lists as line items but are NOT used as a…
Profit & Loss Report Module - Getting Error on Revenue line item
Hi Team, I am getting below error when i am trying to update Revenue line item rule in Lesson 11. Kindly help me to find out proper rule here and suggestion. To my knowledge this error is coming due to additional dimension in source which is not part of target dimension. (Product) Thanks and Regards Akshay Sawant
Solved! How to Get and Automate the System Date into Anaplan Using Python
Anaplan Community!! Hey, I just published a KT article in the Retail Anaplan Group that shows step by step how to get and automate the import of the system date into Anaplan using Python. Hope you like it! Cheers!
calculation
Hi experts, I have three modules below: I wanted to get a subtotal of product1 based on the selected GRP2 & GRP9 product groups in the target module. I tried to use LOOKUP, SUM, and SELECT, I received an error. Please advise me on this case. Regards,
Import to List from Module
Hello Community! Hope you are all doing great. I am trying to import from a Module to a List, but it is not working for me. My LIST is called "Machines by Mill", and the headers in there are the name, the PARENT, the CODE and WORKCENTER: I created a module with those names within LINE ITEMS, and as input, the item that I…
Foratting
Hi, I'm trying to create a Module that has the List of Days of the week as the Rows. I will have to use theses rows over and over again like the Excel Model, but will only allow me to have them once and the days of the week have to share the same formula. How can I format this so I can have it set up like I have it in…
help with formula
Hi, I'm trying to create a function that divides two line items, but the second line item needs to be the value of the 8th month from the first line item. This is the function that I created. 'F01 Funding Breakdown'.Total Funding / IF MONTH(START()) = 1 THEN OFFSET('F01 Funding Breakdown'.Scaled New Originations, 8, 0)…
Level 1 11.3.4 - Formula Error
Hi - I have tried to look through the response of those who have had a similar error but I'm afraid I'm still not too sure how to fix this. Error: Invalid formula for 'REP03 Profit & Loss Report'.Revenue: Automatic sum of 'EMP02 Employee Expenses'.Headcount over Users hierarchy is not possible as Users does not have a…
9.2.5 Activity: Unit Price %
Hi, When I try to copy and paste this formula I get the below error and cannot seem to work this one out. The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product…
Formula assist
Hi I have a module which has a section for a "reviewer" to select a boolean to mark as reviewed. Reviewers are limited to certain persons and certain products. Initially, I had just used the Employees List and created a subset for reviewers which worked fine. However, I now need only certain reviewers to certain products.…
Can Switchover be used on a Daily basis?
Is it possible to do Switch over on a daily basis versus a monthly basis?
L2 Model Builder Training instructions in NUX needs refinement
Customer feedback/suggestion is that the instructions for NUX Level 2 Model Building seem to be geared more toward Classic than NUX (i.e. conditional formatting). Could these be reviewed for possible refinement?
safety stock flag count: sprint 3 level 2
Hi This is my formula for Safety stock flag count: 'INV01 Inventory Ordering'.safety stock exeption count[SUM: 'SYS08 SKU Details'.county made in] but for exam this is showing incorrect. even though data is coming right I don't understand where i am going. Please help me . @Misbah
Level 1 exam formulas to the Line items
I am trying to update the formulas but it shows error. What is wrong for this formula? The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = IF Employed? THEN 'SYS08 Employee Details'.Current Salary / 12 ELSE 0
Total Positions for multiple dimensions
Hi Can there be any other solutions to show total positions having two or multiple lists on rows? Currently total positions is working with one dimension on rows. Thanks Tejaswini
10.2.6 Activity: Add Formulas to Employee Expenses Module
I am getting this error and similar error in other line items. Not sure if i have missed any step earlier. Can someone help. Thank You
List Subset Definition based on formula
Is it possible to add functionality to make list subsets based on formula? Currently we have to either manually select list items to be included in subset or need an import action to update based on subset logic written somewhere else. Can we have option to add formula directly on list subset definition? This will help a…
Filter on a Line Item based on Page Selector, in a Dashboard
Dear All, Need your guidance on something, please!! I want to apply filter on a Module (in a Dashboard based on a Page Selector from first Module). Dimensions of the first Module are Versions using Custom List, Business Units List (which will trigger filter on second module), Business Components List and Time. Dimensions…
Default read/write access for selective access lists
Hi, I would like to enable end users to set up the selective access to a list. It is possible to do so for existing list member. I set up an action for them to run so that the selection of access rights in a module is imported to the Users tab (list write/list read) as shown in the first graph. But when a new list member…
Restricted Currency Conversion
Hi All, I have been working on a scenario where for users of a particular country, I want to show the output in Euro and USD but for other countries it should be only Euro. Is there a way I can control this through logics or I have to create separate pages for users of both countries? Thanks in advance! Best, Shekhar
Sorting in module view/list view
Be able to sort / filter by items in module view/list view etc. Eg sort by cell count, filter only modules dimensioned by time etc.
Time Function in Anaplan
Hi Team, Need your help with the below requirement, We are using 5 line items with a date Format. Line ItemsEmployeeABCDEMahesh12-02-202101-01-202110-01-202112-12-202010-01-2021 Based on the available Dates, we want to find the earliest date through the formula. how we can achieve this Anaplan? In the above example, the…
Missing Data in Production Model
Hello, These line items are working properly on DEV Model. I can choose a value on drop down menu of the line item "DATE CREATION (MANDATORY)", and the data will populate in the other line items. However, in the Production Model there is no data. I can choose a value on "DATE CREATION (MANDATORY)", but the data will not…
Filter Issue
Hi, I have a module with 2 lists (currency and tasks) as dimensions and a boolean line item. Im trying to apply filter on the boolean line item, if TRUE then only the respective currencies satisfying the boolean condition from currency list should be displayed. Im trying to apply filter but its not working as Task and…
Toggling between Regular and Blueprint views
This is a really simple suggestion that should (hopefully) be very simple to implement. Problem: When switching/ toggling between Regular and Blueprint views the scroll bar defaults to the top of the module. In modules with large numbers of line items, this means you have to scroll down every time you switch between the…
User Filter Filtering
Hi Guys I have been trying to solve this issue and having no luck. Reaching out if anyone had a similar issue and was able to solve it with clever tricks Module 1:- dimensioned by the user ( native user list) A user enters no of lines as a numeric value Module 2 :- Dimenshioned by List 1 and List 2. Please note that this…
New UX Selectors on worksheets
Community! I'd like to follow up with @xin question regarding selectors in the new UX. And the answer @Puneeth H P gave in this response,which appears to only work for pages. My worksheet uses one list, P6 SKU which is part of a structured Hierarchy (P1 to P6). I would like to use a selector on the top of the page that…
Help with SUM
Hi Guys, I have a target module containing a dimension which I need to map into a line item. Taking the system module containing the source dimension I have created a line item subset containing the line item in the target and mapped the target line item to the source dimension. In addition to this I have a line item…

Modeling

Discussion List