Modeling

Recognise zeroes and blanks as different data inputs when using number formatting
Can we add a number formatting option (text fomatting causes issues for our users) with a default for the cell of blank (if blank then the cell is ignored) and then if a zero is input it is treated as a number. For example - the default calculation for sales volume generates 50 for January 2018, there is an "override" line…
Ability to view a column in module blueprint showing "Used in Filter", similar to "referenced by"
Similar to how a column for "referenced by" can show me other modules where a line item is used, and "used in dashboard" can show me where it's on dashboards, as a modelbuilder it would be helpfult to have a way to tell where a line item is being used to drive a filter.
View a module's blueprint view side-by-side with its data view
I would like to be able to see the changes I make while in blueprint view of a module affecting its data view in real-time. Currently when I change something in blueprint (ie. a summary method) and have to toggle back and forth to see its affect. Unfortunately, depending on how far down in the list of line items the one…
Need a way troubleshoot a formula by stepping through it piece-by-piece
Much like most coding languages or even excel's formulas, to aid in writing complex code / formulas, there needs to be some way for a developer / builder to see how the individual components of it resolve one by one. I'd like a way to step through a formula to see where it's going wrong, and see values of the components so…
Allow Admin to globally disable "Open Source Module" option based on user role
I would like to be able to set access to the "Open Source Module" option for users based on their role across a model. With this feature in place I could disable "open source module" for non-admin roles, while allowing those with 'Full Access' to open the source module as normal. Win-win. WHY: There are groups of users…
Allow the Create action to work with a numbered list that has no parent hierarchy
The Create action only works with numbered lists that have a parent hierarchy. My numbered list does not have or need a parent hierarchy so to satisfy this rule I have to create a dummy list (e.g. a List called All with a single member called All) and made that the Parent of my numbered list. (I also checked whether I…
Add formula drill down in NUX
Suggest to add formula drill down to NUX. When working with the NUX, there is no formula drill down option. This is a key feature for our users as they need to see how the numbers are being calculated when doing root cause analysis. At the same time, the specific values going into the formula should be shown as they are…
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…

Modeling

Discussion List