-
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.
-
Accidentally changed Switchover date to 2023 when it was meant to be 2022, what can I do?
As the title reads, someone in our org changed the switchover date incorrectly and we lost an entire year's budget, is there a way we can revert this and salvage all of our information? Thankfully we have an archived model but we have tons of connections written to this model and want to continue working in the one that is…
-
Filtering and UX
Hi all, Here is my situation: I got a module (REP_01G) to calculate Version Variance, this module has other dimensions such GL, Project, Currency, Company, and Time scale is Month. And a list of line items as shown below: Reports with Time and Line Items on column will be build. The row could be project, GL, or company,…
-
Input values based on a Boolean formatted Time Period
Hi Everyone, I'm fairly new to Anaplan and currently self studying so please bear with me if this question seem basic. Is there a way for me to use a boolean formatted line item to serve as a basis to what specific months I should put my computed values? The formula will go like this: IF first month of Month Picker…
-
NUX Filter zero
Hi, How can i filter zero balances in my NUX when : -> Time dimension is in column -> Time dimension is sync to the year selected I created another module to have a filter by year but when i am applying the filter i still need to select the time to apply the filter: Regards, Tom