-
Allow data labels to be scaled into thousands and millions
It would be great to add a feature to enable data labels the option to be scaled in thousands or millions. See screenshot below where the whole numbers look too busy on the graph.
-
Level 2 Sprint 1 List Import Errors
When I imported flat files for Sprint 1 1.3 I did not include a parent as instructed, so my country list has only a code, and my location list likewise (see image). However, when I then import this list into G2 Country, it now has no parent listed under region. When I try to write a PARENT(ITEM(___)) formula, I receive…
-
Anaplan Optimizer across time
Hello everyone, Want to use the Anaplan Optimizer across time, and have found out that I can not use a line item running on the native time scale in Anaplan. Hence I am on the quest to create a list of the months and have been following this…
-
Calculate headcount by time
I'm having issues counting the current headcount by month. I have employee hire date, leave date, and projected leave date. I've attached snap shots of my modules. I haven't figured out how to include "projected leave date" into my formula yet. I'm stuck on trying to get the current employees based on historical leave date…
-
Dynamic Number's Format for Line Items based on Italian/English standards
Hi all, don't know if it is possible within anaplan to dinamically change the Number's Format of the same line item based on a specific Country Standard format? Maybe based on the Users Language/Country settings? Since we have both Italian and English Users inputting data inside the same Input Module (and they have…
-
level 2 sprint 1
Hi, i have completed Level 2 sprint 1 exam first attempt score : 60% second attempt score is 90% , but the score is not updated and i am not able to access sprint 2 can anyone help me
-
Calculating the Average Per Cash Curve
Hi, I'm trying to Calculate what my average would be in a certain month using a rate curve. My rate curves are inputs that are located in a inputs module and I believe I would need to multiply them by my average to see what the average would be over time. The only issue I'm having is that my input modules with the rate…
-
Need Calc Help
Hi Community, I am working on this use case. Wondering if this is possible. DAT01 Emp Details Emp | Start Rate EmpA 15 EmpB 16 EmpC 17 SYS02 Zone Module Zone| Lower Range | Upper Range ZoneA 14 15 Zone B 15 16 Zone C 17 100 How can I identify which Zone does an employee falls in. Final result needed Emp | Zone EmpA Zone A…
-
DYK S2 - WEEK 5 (Text String & Text Joins)
Formula per Planual . Watch this video to know more DID YOU KNOW S2 - WEEK 5 - YouTube Thanks, Misbah Miz Logix
-
Model Calendar grayed out in prod model - client has ALM
I think I know the answer but need to verify... in the production model, the model calendar is grayed out. The client has ALM. The model calendar is not grayed out in Dev. Is it grayed out in production because ALM is set up? I'm guessing they need to make changes to the Dev model calendar and push it to production. I…
-
Dynamic chart using line item subset
* Problem statement * Solution approaches * Selection on the chart * Using line item subsets * Step 1: * Step 2 * Step 3 * Step 4 * Conclusion Problem statement A customer from the banking industry recently posed this requirement: "As a reviewer, I want to compare different metrics. Some are absolute, and some are…
-
Import is not working with saved view contains 6 dimensions or Lists
Hi, I am trying to copy the one line item data to another line item within same module by using an import action from saved view(Source) to module(Target) and it is not working in expected way.. Module and saved view have 6 dimensions or lists, due to this i could not bring all these lists into Rows section of pivot option…
-
Level 2 - Sprint 3 - 3.4.3 Activity: Create Country Summary Module
Hello all, I'm having trouble figuring out with this error that I'm getting. Can anyone help me out? My formula is this: 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In] Thank you
-
Dates Format
Can the dates be set to format as 00/00/00? (mm/dd/yy)
-
Versions in a Module
Hi, I have a quick question: in a function, is it possible to refer to a different version on the same module? I had to create versions for each month of data, because I want to import monthly. So, with this i mean, I want the values to remain the unchanged up until the current period and from that period on I want other…
-
Summary method to only include the items visible after filtering
Hi, Please can anyone show me how can I use a summary method but include only items that are visible after using a filter. Thanks in advance
-
Setting Planning year based on date
Hi, I have system module for time settings, and based on Today's date line item I'm trying to set Planning year which is current year + 1, when I'm selecting date between jan to dec 2022 it is showing me plan year as FY23 which is correct, but when I'm selecting date from JAN 2023 to Dec 2023 "Planning year" line item is…
-
Formula Evaluation option in Anaplan
Would be great if Anaplan has a Formula Evaluating Functionality similar to Excel. We build a lot of multi step complex logic in Anaplan and only the final result is shown. Excel spreadsheets allow users to step in to a formula and evaluate it step by step viewing the result at each level. This becomes particularly useful…
-
Value Restrictions on Number Formatted Line Items
Is anyone aware of community posts regarding the ability to add value restrictions on number formatted line items? Examples: Limit user entry to positive values for a user input line item on sales targets. Or limit users to only entering values from 1-100. I think the positive/negative/sign issue comes up a lot when…
-
Archiving Models in Workspace
I have a PROD model that I needed to make a copy of and archive to a new archival workspace. However, I made the mistake of copying the PROD model in the same workspace that the PROD model exists in. How can I take the copied model and update the workspace without causing any issues in any of the models? If possible, I'll…
-
Ability to automatic change a specific value in a table based on changing a value on other table
Hi everyone, While building a model I came across a question. I would like to know if it is possible to update a value of a table after filling another table. In this specific case I wanted that when I changed the "desired average" of the second table the Total Sum FY19 of the first table updated with the new value of the…
-
Revision Tags
I have a question on revision tag and just need some extra clarity. If I make changes in DEV and want to push those changes to DEBUG or PROD model, would the revision tag be created in the DEV model or the other models where I'm pushing those changes to? I've read documentation and videos, but just want to make sure I…
-
Sum values without activating the Sum in blueprint
Hi, Is there a way i can get the total value in a list without activating the SUM in the line item blueprint? I want to save the space so i want to use None in Summary but i need to get the total in another module where i don't have the list. Thanks, Tom
-
Level 3: Sales Planning model to the Japanese Sales Representative details
Hello Can anyone help me on this one, The example on the check build 6.4 are not **** on my end my result:
-
Limitations of the number of lists in rows while crating module
Hi Guru's, I would like to add more than 3 lists in row section while creating the module but it is not allowing me to do so, I know page section but still i would like to add around 20 attr
-
Help getting the Average of a LI in accordance to List
Hi, I'm trying to get the Average of the LI "Principle Balance" by two list Items names "Turn" and "Vintage". I'm not sure if I would use the AVERAGE function in Anaplan or a TIMESUM function. This LI is in a module that is not dimensioned by time. Below is the Blue Print and pic of the module. List Items List Item Blue…
-
Auto generation of Code
Hi everyone, We have list of Activities that are being uploaded in a numbered list with Activity Description and Expense Group as Unique Properties. Requirement is to generate Code in Anaplan based on Activity. I've tried different approaches but not able to fulfill all criteria Example: - Activity DescExpense GroupAnaplan…
-
Waterfall Chart - Positive values start from previous line item
Hi, Anaplan Community, I have a question about the Waterfall Chart in the UX. I'd like to have the positive values start from 0 instead of the previous line item. I would appreciate your input/assistance. Backend:
-
How to remove text before the dash (-) sign
Hi, I have a line item where I need to remove all those before the dash (-). Is there a way to do this? currentexpectedXXX - 123123XX - 12341234 Thanks!
-
Update Entity Name
I have 2 entities where I'm trying to update the entity name in Anaplan. I was able to edit the name of the entities but I believe it's the detailed level that I am trying to edit. Please see my screenshot for the highlight levels I was able to edit and the ones I need assistance with. Does anyone have any suggestions on…