Modeling

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…
How to take the count of a text value that repeats
I have got a text field (column) say X, it has got values x1 x2 x2 x3 wanted to creat a new line item to take the count with same value, for eg: x2 count will be 2 since it has got two entries.
Model Not reloading/opening back to its original state even after cancelling the task
Hi, I am facing an issue in terms of opening a data hub model to its original state for past 6-7 hrs but it is not opening stating “The system is currently processing changes by user XYZ”. I tried cancelling the task, closing the model from “Manage model” section but nothing worked to my respite. I only see “closing” being…
Timeline Chart with Dynamic Start/End Date
It would be nice if Timeline Charts allowed for the start and end date settings to be dynamic (or assigned to a line item). Currently, you have to choose a start and end date when you create a timeline chart, which effectively limits the chart to your initial publication. For example, if you are using a timeline chart to…
Order List Action
Hi We can use "order list Action" to sort the list but the sorting is possible if line items are formatted by Number and Text. Is there any way that we can sort the list by the line item which is formatted by date by using "Order list Action". Kindly resolve this question soon. Thanks Shirisha.
Calculation on opening Balance
Hi Anaplanner's, Need a help on a calculation: Have a module where Time is not a dimension, we have system created list to be used as year, and there is a line item where we need to get the ending balance as the opening balance in another line, which formula can help us attain that? In the below screenshot, we need to get…
Circular Reference
I am creating a model. But when I input something on the line items, then there are errors "circular reference" popping up". Would you help?
You can't access a card
I am getting this message "You can't access the card" contact your workspace administrator. It has been happening to me for the last two days. Any solution for it would be highly appreciated. Thanks
How to remove a filter from a module
Hi Everyone, I made a saved view for the module REV03 Margin calculations which is "Forecast Periods". I was able to make it and put all the required filters inside. But I am not sure why there is a filter sign on REV03 Margin Calculations itself. I am not even able to delete the filter or edit it. If I make any change to…

Modeling

Discussion List