-
New Modeling Experience access bug
I've been using the new modeling experience mode as a workspace administrator and i've been having the bug where I can't access the modules/lists/dashboards I have open, and a notice saying that I don't have access to those resources. Has anyone else experienced this? I can normally bypass the bug by opening the last tab i…
-
Level 2: Conclusion INV05 Shipping Export
First of all, I greatly appreciate this community and the help you provide. I have been wracking my brain, searching, and unable to find an answer. Perhaps I'm over thinking this? I was able to get the sum of the Final Shipping Price in with no problem. Where I'm stuck is the Code. I read that I "will want to import G3…
-
Formula that will pull from another LI every other Thursday
Hi, Need help on how to set up a formula for a LI that will pull from another LI every other Thursday? Thank you
-
Year values to months
Anaplanners, For an input screen, I want to enable users to input at a yearly level and then I want that same value to flow to every month pertaining to that year automatically. This is to make life easier for the end user to not input data at a monthly level, rather do one input at the year. Example. Value for FY 20:-…
-
RE 'Country Made In' Line item of SYS08 module
Hi , Please help me to understand if list format for 'country made In' line item would be G2 country list or subset list of Distribution list for the 3.4.3 Activity: Create Country Summary Module. Thanks Abhishek
-
A Way To Create A Custom Time Aggregate Filter and Selector
Custom Time Aggregate Filter and Selector by @JohnB & @ShaneenW We present our approach to creating a custom time aggregate filter and selector. We look forward to learning a more efficient approach to creating a time aggregate filter/selector or tips/tricks to shorten the approach below. 1. Create a flat…
-
2.4.7.1 Create Demand Forecast Grid UX saved view Not formatting
I entered and cross checked my data inputs and formulas. The conditional formatting is not functioning. Please help
-
Calculation of modules & Size....
Hi Everyone, Can anyone help me to understand, how we are calculating the module size in GB format? If I want to see the actual size of my modules in GB then, do i need to enable any option in Anaplan. Regards,,, ___________________________________________________________________________________________
-
Stuck inside a subsidiary view
Hi All, On a number of occasions when reviewing subsidiary views I have found that I am not able to return to the default view. Despite, selecting 'default view' from the tool bar I am forwarded back into the blueprint. The only remedy I have found that gets me back to the default view when this occurs is to close the…
-
How to get the Index of a Numbered List Item ?
Hi guys as the subject, I want to get the Index of a Numbered List Item, what attribute/property should I use? the Propeties I've tried: (Item )Index (Item )ID (Item )Number (Item )suffix by the way, what is the data type of the index? Thank you~
-
2.4.11 Activity: Create Roles and Test as End Users
Hello! Would love some guidance here. Roles were already created And for Product Family Manager I have Write access for DEM01 but not sure how to navigate the rest.
-
CUMULATE circular reference
Hello, There are similar posts on this topic, but none of the solutions seem to work. I am trying to create an inventory calculation that allows the user to delay/push production to subsequent periods. Then, the total production that has been pushed will be produced at one time. CUMULATE is currently used to aggregate the…
-
Summing of list items to another list item in the same list
Hi There is a requirement that we need to sum list items total to a specific list item in the same list based on some selections User selects Yes/no one line item(drop down) and Revenue method on another line item(drop down) Lis items which are having Yes should be summed to the % revenue method list item attached…
-
Different switchover dates for financial statements in same model
Hello, I am brand new to Anaplan and am building a long range plan that has P&L, BS, CF. Our actual version in AP for the P&L is an import from our accounting software that is actuals + forecast = total FY year. For example, our FY year ends 6/30 so if I am in Dec, i will load a file that is 6 months actuals and 6 months…
-
display name not referencing module line item
Hi: Any help would be appreciable. I have numbered list and has property display name. It has formula to reference from one of the module. However it is not displaying anything on that display name property section even after I set display name property. Is there anything I am missing? Thank you
-
How to connect a long list of vendors with multiple other lists
Does anyone have experience creating a module with a long list of vendors (4000+) by multiple dimensions (market, department, legal entity, business unit) without breaking their module? Currently we are only able to show by one dimension but we really need it by all four, would greatly appreciate any insights on how to…
-
Anaplan put to rest mode after 60mins
Hi, May I know the reason why Anaplan model put to rest after 60mins ? When another user tries to login again, it takes time before the model re-open. Thanks in advance for helping, Tom
-
Model
i want to learn level 3 can u please share link of the course with me . i am not able find that course
-
Last day of month for line item
Hi, How do I get the last day of the month for a given line item when the module is dimensioned by Time? Please help. I need the last day of the month for the line item in the screen shot.
-
Comparing text formatted line items
Hi Team I am having a module with two line items(Error 1, Error 2). I need boolean to be checked if the texts in two line items are not same and it should retrieve the text which is not same in another line item. ListError 1Error 2BooleanOutputProduct 1Text 1,Text 4Text 1,Text 4FALSE Product 2Text 1,Text 4Text 4,Text…
-
Issue with formula editor getting worse
Hello All, A couple of months ago I called out an issue (confirmed to be a known issue by Anaplan support) about the formula editor in the new modeling experience. You could not reference a list item by clicking, you had to type the entire reference.…
-
Timesum with Date
Hi I want to use Timesum function. In this page, we can use Timesum function with end date to start date. https://community.anaplan.com/t5/Idea-Exchange/Dates-in-Timesum/idi-p/89565 But in Anapedia page, it is not suggested to use Date. https://help.anaplan.com/13d8b551-4e13-413b-a39f-f25579d21e38-TIMESUM Is there some…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
When i am running the process as described * Run Process 9 Import Data from the Hub. I am getting error as Any help will be appreciated.
-
How to pull property data in line item
Hi, I have module with two lists and in that module for one line item i need to pull data from one of the List's property. for example: i have Employee list with its property as "Position" and i have module with Employee & Product as List and i have Line item as Position. So i need to pull Position of all employees in that…
-
Help needed: formula is invalid
Hi, My name is Usha Priya. I am trying to add formulas to the SYS01 Time Settings by Year System module. I get a message saying the formula is invalid. Please find below the screenshot. I need some help to solve this issue. Thanks.
-
Formula to get code of a parent
Hi, What formula can be used to get the code of a parent list inside a flat module? for example in this particular module the parent is a numbered list and I want to bring its code in the 'Code' line item( Text Format). What method can I adopt to achieve the same? Thanks
-
Sprint 2 Activity 2.3.9.1
I’m really stumped here on this activity and can figure out where I went wrong. Could someone assist.
-
Need Help: Circular Reference Error
Hi Anaplan Community, I have been thinking of ways to pull Prior Year value into Current Year. Previously, I used OFFSET() formular where I would offset -52 weeks. I have created a demo module below to showcase the original formula, the formula that give me circular reference error and the backup formula. Recently, to…
-
Anaplan Time Days Mapping with Custom Days List
Hi, I have created a module to map Anaplan days with Custom Days List (snapshot attached). But while I am trying to use the Custom list in Sum formula it is not giving any value. Time settings at my end are at week Level (4-4-5). I have build this mapping because while aggregating days into months gives wrong summation due…
-
Issue with formula editor :clicking on a list or list item does not work anymore (e.g. for finditem)
Hello All, Since the new formula editor release, I noticed that when I am editing a formula and go and click on a list or list item, the formula does not get populated with the list / list item. Now instead, I need to type the name of the list (e.g. when using FINDITEM or ITEM formula). This is bad! Is anyone else having…