-
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)…
-
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)…
-
Need to set a particular list item as default in Dashboard, other than ALL
Hello Everyone, I have Flat List by name: ABC, This list i have selected in a Module:1. This Module1 i have published on classic DB. The list contains list items 1,2,3 and ALL. Requirement: I want to set 1 as default list item on DB, whenever any user opens this DB they should see the default as 1 as the list item. But in…
-
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
-
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…
-
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.
-
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.
-
Add dimension name in NUX
Hi, Is it possible to add the dimension name at the top of the GRID in NUX? Regards, Tom
-
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…
-
Anaplan is not allow my export showing message Excel workbooks cannot support more than 65536 rows?
-
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.
-
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…
-
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…
-
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…
-
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
-
Difference between the two types of CSV Exports
Hi, Can anyone help us understand what is the difference between the two export options highlighted below. I have tried out both but don't see any visible difference. Regards, Aakash Sachdeva
-
Multiply Line Item by Extra Dimension
Hola, (That means Hi in Spanish) I greatly appreciate any help you can offer. Thank you in advance I have a line item and I would like to multiply it by another line item in a different module. This other module has an extra dimension that we need to calculate. "New Funding by Turn and Credit" is my line item. (SS7) This…
-
Bulk Copy Action
I am aware that I can add Bulk Copy as an action via Action in Model Settings Bar however to set this up I have to select the target and source version/list member. Is there any way to set this up so that I can select the target and/or source when the action is being run?
-
Moved: Model Building Level 1. lesson 9.2.5 updating unit cost % to 5% not able to do
This discussion has been moved.
-
Learning Anaplan
Hi Team, I am new to this community and exited to learn about Anaplan model. Looking for some tips from where to start learning about Anaplan and get familiar with tool. Can you share the link to get started learning about Anaplan. Any help would be appreciated!!