-
Picking up opening balance
Hi there I have two modules. Module A has by week time scale and module B has by month time scale. If module B want to pick up opening balance from module A, what formula should I use? PS, has set up the "The first week?" logic but don't know how to pick up the value from module A. Thank you.
-
List items maximun
What is the maximum list items, can I add in a list?
-
Value is not getting exported
Hi Friends, I am trying to export but only Time and Lists are getting exported. And no Line Items and their values. Please tell me, when it happens and what do I need to do?
-
Summary setting for module dimensionalized by years and fake months list
Hello, I have a module dimensionalized by years and a "fake" month list (and other dimensions) so I can see line items month to month, year over year. I'm pulling the data from another reporting module that's dimensionalized by time (month) so I'm using a line item to map months to years and using that as a lookup. This…
-
Ability to enter decimals without leading zeros via new UX forms
When we are using the forms in the new UX to create list items, the form with a number formatted line item is not letting the user enter decimal numbers without leading zeros ".05". When entering the number directly into the cell, it accepts it but when using the form, it gives an error saying it is not a valid number.…
-
How to hide summary item in dropdown list?
Hi Experts, I'd like to ask how to hide the category summary in lists. The screenshot is what I'm developing now. In this module, client set parent and child product for set selling. In this dropdown list, is it possible to hide parent category here?
-
Formula for Summary
I have a case, i want Monthly Amortization Line item can show Quater amount. but not show because on Summary have Sum,Time:Formula. Can give me a answer. Thank you. Help me
-
Level-2 Certificate
I have completed the conclusion exam of Level-2 and uploaded the model history also. Past 24
-
Active Child list members under a parent
Hi - Say I have a hierarchy with two levels: L1 and L2, L1 being the parent. Not all L2 members are at a point of time active under L1. So, we have a module that specifies which L2 member is active in a month (identified by a boolean). For disaggregating the data from L2 to L1, I need to ensure the volume is disaggregated…
-
Find formula
Hi Friends, Do we have any special formulas for the below calculation.
-
False Boolean Action
Hi Team, I have a Override Boolean line item in 1 of my Selective Access modules that I would like to create an Action for to set all the items to FALSE. This would be done when the Selective Access admin tasks are being executed and we wish to start with a clean slate I know that I can go into the module, set the Formula…
-
Filtering line items or lists by another list
I have a module of multiple different input line items, but those inputs vary by the elements in a list. For example the North region (list item) has 2 of the 5 inputs, and the south region may have all of the inputs. I want to be able to use a filter to only show those applicable input line items for its respective list…
-
Level 1 Model Building
Hi Team, On the 'Introduction to User Experience' slide, I am not seeing the 'Next' button getting enabled even after selecting 4 differences for 'Model Builder' and 'End User' views. And hence not able to progress in the course. Has anyone faced this issue? Thank you Gaurav
-
Formula help requested
Hi Friends, I am struck with a query. Need your assistance to proceed forward.
-
Calculation Function / Formula context specific suggestions
When typing in a calculation function, show a dropdown box that provides possible matches Example 1: In the formula box when you type "Da" a tooltip suggests "DATE, DAY, DAYS, DAYSINMONTH, DAYSINYEAR.." etc Example 2 (List/Module specific): When typing "Employees. " a tooltip suggests your available Properties or Line…
-
New List creation
Hi Friends, I have an existing module with Order ID. I want to create new List as follows.
-
Model Calendar - Calendar type on Weeks, Module Time Scale - Day option
Hi The notes state that for Weeks calendar types, the available time scale are 'Week, Month, Quarter, Year' as per screen below. In a Weeks calendar types, when a module was created, the 'Day' was available for selection. Why is that so? I would have thought 'Day' should not be there based on the notes above or did I…
-
OEG Best Practice: To version or not to version?
One of the most common questions I get asked is when to use native versions versus using a general list to replicate versions. As is often the case, the answer is: it depends. Let me run through some key areas to help you with the decision. Functionality What functionality do you need? We always advocate using native…
-
transform data's timescale
if Module A is in weekly time scale, Module B is in yearly time scale. What formula should I use to pull a line item from Module B to module A? Thank you.
-
MBL2 Conclusion INV05 Formulae
Hi, I have spent a long time trying to figure out the formulas for the line items in the INV05 Shipping Export Module. For Shipping Costs - 'INV01 Inventory Ordering'.Final Shipping Costs and I know we need to also bring in the SKUs from one of SYS modules. However, I am unable to bring in the SKUs. Any help would be…
-
If I don't mark a list as Production List, what will happen? Since I don't modify my list often.
As I read, if I mark a list as Production List. I can make changes to it, even in Deployed mode. What type of changes? Properties, Subsets, Code?
-
Computation with Price Escalation
Hi Guys, I would like to ask something regarding a formula I have been working on. See the table below. Price Escalation formula = Input Avg Selling Price = The Jan 13 value is constant referenced to 2.3 which is in another module. While the succeeding months starting Feb 13 to Mar 14 the formula is Avg Selling…
-
issue in anaplan level 2 training content. Help!
Guys I think there is a serious issue in the formula suggested for building "INV01 Inventory Ordering" module in this course. The requirement is to write a formula that would result in "Final Shipment Amount" to get reflected in the corresponding week as "delivered value" based on the "shipping time" of the "selected mode…
-
Ability to move to different Workspace from the model itself
Current State Scenario: If you are working on a model and you wish to move to another model in different workspace you have to go back to Home screen then go to Manage Models-> Select Workspace ->Select Model Idea: From the current model we hit Manage Models->Select Workspace-> Select Model. This eliminates the need to go…
-
Improve a Numbered List
Improve a Numbered List
-
How to create an action to assign parent to item in system module
i have a flat list and want to create a system module having the flat item list and now i want to assign parent for that list item in the system module. How to create the action to assign parent.
-
Multi Scenario building
Hi.... I hope someone out there can provide some insight... I need to built something there I can recorded different scenario!! I already have a Scenario Version in my "Versions" however but I can only take one set of scenario "setting", I cant built anymore versions as every time I add a version it increase the size of…
-
Many to Many Dependent Dropdown
Hi, I have two lists, L3 - Plan and say Product Code. Now the Product Code dropdown line item in a module needs to be dependent on the plan line item. For this, I created a L3 - Plan formatted property in Product Code list to be used to drive the dependent dropdown. However, since it is a many to many mapping, a Product…
-
User Roles
Hello, I wish to create a dashboard where I could show the user - the roles of all the users and if they wish to change the user role they can update it from the dashboard, how can we do that? (I need an understanding how to display the user role of users on the dashboard) As deleting a user from a dashboard is not…
-
Formulas Text
I want to write Sweet for all taste. Please tell me, how can I do it?