-
Maximum Limit on Adding Hierarchy lists.
Hello, I need to understand what is the maximum limit on adding the hierarchies? I have tried adding upto 50 lists and the parent of List 50 was List 49. I am not sure if it has any limit or we can add without any limit. Can any one could help me?
-
Quarterly Account Sales Revenue Targets
Hello, I'm in the process of building the module for user story 1.11 and I am struggling to get the correct formula. I need to convert yearly data to quarterly data using the SYS99 Time Settings module (only line item dimension). My formula currently pulls the yearly total for each quarter which is incorrect. Any guidance…
-
Issues with Round function
I've noticed an issue with the Round function while going through my L2 again. None of the available parameters seem to make it possible to get an accurate whole number rounded up. In this example, I want the total (237.9) to be 238, not 240.
-
Switchover and FY year settings
Is there a workaround on: 1 Updating Switchover period from the NUX App 2 Is there a workaround on updating the Current Fiscal Year of the Time Settings from the NUX. Please your reply will be really helpful.
-
Wrong date when doing an import
Hi everyone, I am importing data into a module which gives me the employment date of a list of employees (among other info). The module doesn't use time as a dimension. The import goes perfectly well, it doesn't mention any error. But then some of the dates are wrong. So I tried to copy these directly from Excel (simple…
-
Bolean condition based on Season
Hello everyone, i've been recently struggling with a dev. I have a list in my model called Season (I work in the retail industry). This season list is composed of items that are like this : 23SS, 23FW,... that correspond to the seasonality of the product (for instance : 23SS stands for spring/summer 2023, 23FW stands for…
-
Quarterly Account Sales Revenue Targets
Hi @JaredDolich @Misbah , How are you? I completed the User Story 1.11. But I have a question. When I select All Account, the % of Account Sales Target aggregate automatically. Any help would be appreciated. I am looking forward to hearing from you soon. Best regards. Wei
-
Level 1 Model Building Exam - Activity 6
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from SYS08: I keep getting the wrong number whether I use EMP02 or EMP03 in the formula.…
-
Calculating line item based on diffferent values in the list
Hi Anaplanners, I have a module dimensioned with 2 lists, loc1 and sample. Sample has two line items Sample 1 and Sample 2. There is a line item called Transportation. I want to add another line item called Transportation Sample1 vs Transportation Sample2 which should be Transportation for Sample 1 - Transportation for…
-
How to Find Combination of List
I want to Find combination of List. I have relationship of Customer-Product and Product-Supplier. Then I want to find combination of Customer-Supplier. Now I don't want to make Lineitem which has "Customer*Product*Supplier" as Applies To because of memories. What kind of formula should I set?
-
Formula Help (Condition Statement)
Hi, I need help on creating a condition where if one LI is lesser than another LI, then my intra-month growth amount must be less than my write off amount. Not sure how I can make this condition happen in Anaplan. Please advise. Thank you
-
Add dimension name in NUX
Hi, Is it possible to add the dimension name at the top of the GRID in NUX? Regards, Tom
-
can someone help me understand the difference between structural information and production data
-
Anaplan formula to Lookup Balance Sheet description
Hi Anaplan Community Please see email attachment with all details for my question relating to. I have an “Account Major Properties” module with a line item of “B/S Line Item” where I want to populate the valid Balance Sheet line name, from the list “Balance Sheet Lines – NEW”, based on the Account Major (e.g. GL Account)…
-
Model Optimization : List Sort Order
Hello everyone, Is there any further documentation to read regarding optimizing the model. We saw this in the checklist. Does this mean we have to Sort the List? If yes, via what property of the list (Code, Display Name or Numbered List arrangement) Thank you very much.
-
Hierarchy Filters
Hi, I have a requirement where in if user selects a Boolean(Show Ending Balances) then it should show only ending balances (which is a top level for L1 description types of list) along with Ending Balance line item. Currently I have built the logic but when I apply the summary as formulas it throws an error. But previously…
-
How can I Filter out certain Time Periods in my Time Filter?
Hello, I'm trying to include the following time periods - Month, Quarter, and Year totals while excluding Half Year. Because of other use cases I cannot remove Half Year from the time scale. Has anyone encountered this before and how did you solution it? Thanks!
-
How to truncate or make this formula more efficient
Hi, This formula in our model is possible slowing down the load time of our model. The formula has the logic we need but I believe it can be written better for loading time in our model. Formula: IF 'S04 Version Mapping'.Budget THEN IF 'S01 Time Settings'.Funding Holidays? THEN IF 'S01 Time Settings'.Weekdays? THEN IF…
-
Create a list out of on data inputs
Hello Community, I am quite new to ANAPLAN so a bit lost sometimes and not all knowledgeable yet! I have created a simple list of numbers (#1, #2, #3…) to allow our users to input data into a table (inputs module), in different fields. After the data is in, a line item picks up a final description with a concatenation and…
-
Copy/Paste & Copy Across/Down in NUX
Hey All, One of our cards in the NUX will now allow copy/paste or copy across/down. The model is deployed, and that particular line item has a dependent list format. The odd part is this works find in the dev version both with and without dependency in the list format. My only guess is that it's a numbered list, and we're…
-
Page Selectors Best Practices?
Hi, Is there some common techniques when publishing page selectors to a page verses publishing to a module?
-
How to Move From Custom Time Amortization list to Line item with Time Range Mapping
Hi All, Can any one Help me to copy data from line item 1 to line item 2. Format for the both line item is number only. Dimensions : Line item 1 - Product list, Amortization Month list, Line item 2 - Product List, Time. Issue : I created a module, where I have a mapping between amortization month(used as module dimension)…
-
Anaplan script is failing while executing remotely
Hi, I am trying to execute Anaplan script remotely but its failing with below error. Absolute path to JAVA 8 executable not provided. Will attempt to figure out path from JAVA_HOME or Windows registry... JAVA_HOME is not defined, will attempt to fetch value from registry... Checking Windows Registry for Java Version...…
-
ALM Tag
Hi All, Quick question on ALM - On 31st Jan I developed something and create a revision tag and sync it to prod. And on 1st Feb I again develop something and don't want this to be in the prod but I wanted to be on the dev model. On 2nd Feb I develop something and create a revision tag and sync it to prod .I do not want to…
-
Bringing prior year loss into current year income calculation
I have a requirement to include the net loss of a product in the next year income calculation, but only if it is a loss. I keep running into circular references. Any suggestions? Year 1 Year 2 Year 3 Year 4 Revenue 100 120 140 160 Expense -150 -90 -80 -100 Prior Year Loss 0 -50 -20 0 Total -50 -20 40 60
-
Have to design a model with L5 hierarchy but Business says sometimes they might have an input at L6
Have to design a model with L5 hierarchy but Business says sometimes they might have an input at a level below for some regions. So should I be creating L6 or create a separate list and link it the values to Its level 5/parent in some other way around.
-
Have a Budgeting scenario to streamline client's process - Recommendations on multiple models?
Is it recommended to have multiple models where aim is almost similar throughout for all regions but the way of calculations are different for each cost center.
-
Dependent dropdown
How Can I add filter by country and filter by segment in this: Accounts are dependent dropdown set up on country. Thanks -Pooja
-
Load monthly data into weekly time setting model
Dear Anaplanners I have a dump question whereby I cannot get it over yet. I have a model whose time setting is designed as weekly (for later stage replenishment planning) While the demand forecast is still by month, so I have an import module to load monthly history sales dimensioned as below: My source csv file looks like…
-
Input time range
Hi All, Is there a way to restrict users inputs of a number (formatted) line item to values between -1 and 1. I cant use a list for this as users are free to add any decimals. Thank you in advance for any suggestions.