-
How to distribute the value of line item equally.
Hi, I have 2 line items where in one is Boolean and other is numeric(percentage format). if the Boolean item is checked for that property then the value has to be zero for that particular property and its value to be equally distributed to the other properties. for ex: In the screenshot the %alloc of the property 1 is 10%…
-
NUX - Limit Open Source Module option
In the Old UX we had an option to remove the "Open Source Module" option from dashboard. I couldn't find any similar option in NUX. Am I missing anything?
-
EMP02 Expenses are 0 after a certain date in my model
I am trying to figure out why my expenses stop in Sept 2020. I have reloaded my data to EMP03 three times. I have been trying to figure out what is wrong and I don't know what else to look at. Any suggestions?
-
Date formula: Month +3, Day -1
Hello Team, I am trying to write a formula that takes an inputted date and outputs a M+3, D-1 formula. The very tricky part is input for 1st of month should then be M+2 / D is last day of the month Examples: * Input 6/5 -> output 9/4 * Input 5/25, -> output 8/24 * Input 3/31 -> output 6/30 * Input 1/1 -> output 3/31 *…
-
Level 1 Model : Dimension of mapping used for lookup doesn't match any dimension of the result.
Hi, While adding formulas to the line items in EMP02 Employee Expenses we were asked to enter the below mentioned formula BonusIF Employed? THEN Salary * 'EMP01 Employee Drivers'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Country] ELSE 0 but it's throwing an error "Dimension of…
-
Model Name as a Field in Blueprint view
Hello there, I had an idea, I believe this idea can open up a lot of possibilities as to how you can leverage the blueprint view for Model optimization and performance management. I see that the newly released Module Name field has opened up a lot of possibilities when analyzing my blueprint views. I am trying to build a…
-
Alternative hierarchies - Numbered List Required?
Dear All, Do I need to use numbered list for the lowest level of the Alternative hierarchies? I read through couple of examples and training, which all use numbered list. I was wonder if this is necessary. Thanks, Lily
-
Add Dynamic Actions
Please add dynamic actions that only run based on a boolean line item. For example, when importing transactional data other lists may require updating if a new item is detected. If actions in a process could dynamically run based on boolean line item, model builders could improve model speed during updates.
-
Add Conditional Formatting to Action Cards
Please add the ability to conditionally format actions cards within the NUX. Superficially, may appear minor, however this would be a powerful way to guide users in apps and provide workflow. For example, a page builder could highlight any actions that require running. As a additional benefit, this would help model…
-
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…