-
Level 1 11.3.4
Hi, Even if I enter the formula as instructed, The sample and answer are different. Any help is appreciated. Thanks. This is my model: This is the should be:
-
Level3. Account Territory
Hello, I am using SYS07 to load territory data in QUO07. I understand that they have different dimension however, Anaplan accepted the reference but not showing the info. any hint how can I solve it? SYS07 QUO07 Thanks.
-
Level 2 Model exercise
Hi team. what is the formula to be applied for line item Has Data? in the spring 1 exercise 1.5.7.2 Add Formula to SYS13 Line Item the hint is not helpful regards, Baskar
-
Level3. Net Commission%
Hello, Can you please guild me what does "Net Commission%" represents? Thanks,
-
Need help for the optimizer error
Hi Team, We are getting error while running the optimizer. Can you please guide whether the error is due to time or some constraints or some data issue? Please find attached the image for your reference.
-
Error while updating formula for REV05 unit %
HI There, While updating the formula for REV05,I am getting the following error. Can anyone help me out. 'REV04 Price Growth Rates'.Unit Price%[LOOKUP: 'SYS04 Location Details'.Country, LOOKUP: 'SYS06 Product Details'.Product family]
-
Level 3. QUO06 Tenure Calculation
Hello, Can you please review my formulas here: i am not sure why I see 5+ years here for everyone: Thanks,
-
Level 3. Build Sales Role and Sales Reps
Hello, Sales Role and Sales Reps# are flat list in Sales Planning Model. In the Sprint2, the ask is to create import to build them up. I am using SYS09 Employee Details module in Data-Hub, but it is not working. Any Advice? Thanks
-
Boolean Filter for Salary Rank function
Hi, I want to only show the top 10 earners in each department (List hierachy E1 Department is top and E2 Employee below). I have created a RANK that will give organize numbers lowest to highest based on each department, But the numbers do not "start over" for each department. So there is only one department, that has RANK…
-
Level3. Create Action with filter
Hello, As explained in the Level3 study material, I added country and segment as properties to "G4T Territory>Account#" but I still can't see them in filter section when I create an Action. Please advice. Thanks
-
Help needed to get the data by pulling from two time scales
Hi, i want to get volume data based on the line item 2 to my target module which is at year level. But my source having the time dimension while i am writing the formula no values are coming
-
dependent dropdown multiple condition
Hi, Is there a way to make a line item( dropdown list format) to have multiple conditions? example : I want my GL account dropdown to be filtered based on the account type selected (parent of the GL account) and based on the cost center selected? GL account is dependent on both the cost center selected and the account type…
-
TEXTLIST- multiple dimensions
Hi Could any Anaplan pros please assist with a TEXTLIST aggregation? I am not sure how I would do this over multiple dimensions. It is basically concatenating all the applicable pages numbers into one text based line item for each employee / report version / user. I have attached the blueprint. The line item I am trying to…
-
Formula for calculating Time Coverage
Hi everyone! I'm having trouble in resolving these request in Anaplan. Basically I've got 2 line items in a module with Time Scale Weeks: Expected Sales Quantity = Qty of Product that is expected to sell in every week Final Stock Quantity = Qty of Product in Stock in every week The request is to calculate for each week of…
-
L@ Model Building UX pg's
Hi, Not Understanding how to choose which Context Selectors levels are needed for certain List. It is on the Exam and I have watch the recommended videos and just need more explanation. Thank you
-
Breakback with rounded integer numbers
Hi, Is it possible to set a Breakback function with auto-rounding? We're working on a project where exploiting breakback is useful. Product units should be integer, never fractional, but we can't find how to auto round numbers derived from breakback function without setting a process. Is there a way to let user insert a…
-
Browser Slowness when Model Building
Has anyone else noticed that after 15-30 minutes of model building activity (opening modules, opening lists, updating formulas, opening split views, toggling from blueprint to module view, etc.) that browser tabs slow down and stop responding, and has to be restarted. Been an issue for a few weeks now. Hardware and…
-
Mapping time when importing csv file
Hello I have an issue when mapping the time when importing a csv file could you pleae help?
-
Mapping time when importing csv file
Hello community, I am blocked when mapping the time when importing a csv file: my model is set as Year and in my csv file I have a colum named Year with FY. I have error when mapping those, please see images below. Can you please give me some ideas?
-
Need a filter for FY months
Hi community, I need a formula to filter my module months based on current fiscal year. For example, if my FY is 24 (FY24), I want to filter the module to show all months for FY24 (Jan to Dec). After that, I want to show text 'Actual' for actual months and text 'Forecast' for forecast months. Below is a illustration of…
-
Level 1 10.2.6
Hi, Even if I enter the formula as instructed, it is not reflected. Any help is appreciated. Thanks.
-
Level3. Territory>Account module
Hello, I created a module in Data-Hub to transfer the territory>account to Sales Planning model in a numbered format to use as a dimension. However, I am pretty sure that something is incorrect with my module cause all the accounts listed in each territory repeatedly. Any idea what is wrong here? Thanks,
-
Managing number formatting between countries
Hi everyone, I'm looking for advice on how to dynamically change number formatting in both the Anaplan model and UX based on the region or country. We have a development model that will be deployed across two countries, but they use different formats for decimals and thousands separators. For example: Canada uses a comma…
-
Level 1 9.2.5 Unit Price %
Hi, When I try to copy and paste this formula I get the below error and cannot seem to work this one out. The formula for 'REV05 Price Growth Rates Staging'.Unit Price % is invalid: Unit Price % = 'REV04 Price Growth Rates'.Unit Price%[LOOKUP:'SYS04 Location Details'.Country, LOOKUP:'SYS06 Product Details'.Product Family]…
-
Level3. Territory>Account module
Hello, I created G3a Territory in Data-Hub rolled up to G2 country. And loaded with Territory Data via CSV file that has been provided in the sprint 2. I created a sys module with a dimension of G3a Territory and Account to create the needed info for Territory and Account# in the Sales Planning Model. However, I see some…
-
Anaplan does not sum the filtered list items but it sums all list items
Is there a way to sum only the list items that I filtered? Now All directions is always the sum of all the list items and not only the list items that I filtered
-
How can I permanently HOLD the TOTAL figure and let the Breakback happen?
Hi Community, Need your help if you have a smart solution to HOLD / LOCK the Top/Total of certain dimensions of a line item which is Breakback enabled! Example screens is given below: So, all I want is to HOLD the yellow circle i.e. 1849 amount and let the below gets change which is 4 levels hierarchy.. We know the HOLD…
-
Loading .csv File issue Numbers dots, commas
Hello, I have an issue when loading my .CSV file, the number I get they are not right: when importing, the system takes the dot from the numbers as being the number not the decimal. For ex, in the CSV file I have 22.2 so twenty-two point 2 and in Anaplan I get 222. Can anyone help with that please? thanks
-
Anaplan Level 2 Conclusion - Create Demand Export Module and Create a Saved View
Can someone help me why I am getting different demand number pulled up? Instruction: My Anaplan Blueprint Mode: My data Check your Work:
-
Level 3. QUO01 Territory Account
Hello, In the QUO01 module, I am using formula below to get target number, but I get 0.00; I even tries to add LOOKUP account names but still no luck. Also, for Assing>1 I am writing this formula, but it errors out: IF 'SYS07 Territory Account Details'.Count[sum:'SYS07 Territory Account Details'.Account> 1 THEN TRUE ELSE…