-
Increase the character limit of the MAILTO function
The MAILTO function currently has a limit of around 2000 characters and any greater than this will prevent the message from being opened in your chosen mail app. This is normally fine for standard English alphabetic characters, but can cause issues for non-English alphabetic characters. For example the Japanese character キ…
-
SUM vs LOOKUP - Visual Representation
For those like me who like visual aids, I put together a diagram of when to use sum vs lookup in a formula. Hope this helps if you are struggling when to use each.
-
Multiple lists as only dimensions and LOOKUP
Hi, I wish to lookup each and every individual cell in a module that is dimensioned by 2 lists. No time dimension. I have a Module "Sequencing" dimensioned by 2 lists - MonthNames and Offset. Attached are screenshots of the two lists and the module. The module has one line item - a % number that determines for each month…
-
Who's interested? Office Hours with Rob Marshall - presented by the Anaplan Community
Alright Anaplanners, we’re giving you direct access to Anaplan experts to answer those tough questions. Is there a formula you are struggling with? What about a list or line item? Getting stumped working with a specific dimension? We’ve got the expert and the answers! How does this work? Well, if we’re honest, this is our…
-
Using subsets as conditions in the formula of list properties
Hi , I need help on the subject . I would like to give a conditional formula for one of my list properties based on the list subset involved. Please let me know if this possible , if yes, how ? Also if not, please suggest alternatives. Thanks in advance! -Aishwarya
-
Have total in summaries to only include sums of only the items users have access to
It would be useful to have a sum that only included values from list items the user has read access to. So if you have a list with items A, B and C, and one user only has access to A and B, they would still be able to see a total of their view (A and B) . Why this would help: When using selective access, not all views roll…
-
Circular References - OFFSET
Hi, I want to create something like the below example, but Anaplan returns circular references. Could you please give me an idea? Example In the above example, I input below formulas Last month stock = PREVIOUS(Stock) Consumption = get from different module Planned Received Amount = OFFSET(Recommended Order Quantity, -1,…
-
Level 1 MB Lookup function issue
Dear, I am trying to apply a lookup formula to retrieve data but I always get an error message that is not mentioning what is the error. I think my data should be ok, as well as the formula I entered but still I get error messages. I attached the input of my formula and the error message i get. Many thanks in advance! kr,…
-
Extend the number of future years
For the purpose of calculating lease contracts in IFRS 16 it's sometimes needed to have wide time ranges in the model. Currently, the amount of future years is limited up to 50 years and past years up to 20 years (link). This means you have a maximum time range of 70 years. We experience that some lease contracts extend 70…
-
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…
-
Additional History Filtering in a model, plus history extraction/access
On the History tab, provide more data filtering options such as filtering by history action name. For example, my customer needs to filter only user-security related actions for detailed audit history beyond the level of detail provided thru Audit in Tenant Admin. Ideally we would like to have access to the history records…
-
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…
-
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.…
-
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
-
Find formula
Hi Friends, Do we have any special formulas for the below calculation.
-
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…
-
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.
-
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?
-
Importing data Module-to Module
I’m trying to put Lookup and SUM function but every time it says ‘The formula is invalid’ and it doesn’t exactly tell what is the problem. I want to import data in Module F from Module A and Module B. I tried to use below formula for importing Module A data to Module F as they both have same dimension so i thought it would…
-
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…