-
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…
-
Filtering a subset
Anaplanners, Is there a way i can filter a subset ? So, we have Projects module, where each project can be either active, inactive or done. This is a list formatted line item. However, the option to select done should be based on another line item in the module, actuals uploaded : Yes/No ? If the boolean is true only the…
-
Superset Choice (from Time Ranges)
Could someone please explain what's the use of this particular time lookups function?
-
Anaplan level 2 sprint 1 exam passed but not count
-
'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Price & 'REV02 Volume Inputs'.Volumes * 'REV
I am facing problems with both formula's. Please help me i have been stuck cant move forward if anyone could explain what the problem would be and give me solution to it.
-
Alternatives to Rank in Polaris engine
Hi Community members, I am looking for some alternatives to assign sequential ordering in Polaris model as the default "Rank" function is unavailable there. Thank you!
-
Average of previous year and current year
Hello community, I need to calculate average of previous year end (e.g FY23) and current year end (e.g. FY24). Logic should be FY24 + FY23 / 2. How can I return these vales from a line item which has both FY23 and FY24 numbers. Any ideas much appreciated. Thanks Kal
-
Lock Lookup. Possible?
Hi everyone is there any possibility to lock the lookup function when using offset? what i want to achieve is when i change my time period, the awarded will take the current period in module Construction Forecast-Awarded and will be place in Awarded column. same thing in Awarded 2nd Month, it will display the second month.…
-
What is the maximum number of dimensions (aka list) per each Anaplan module ?
-
Display next 2 period (month)
Hi everyone. I'm not quite sure if i'm using the correct formula in displaying the next 2 month period. if I selected Oct 24 in time dimension, the result would be display is Dec 24 in my column. is used this formula NEXT(NEXT(ITEM(Time))) which is running and no error. Just to make sure if i'm using the correct formula.
-
Level 3. Account Review UX page
Hello, I created a saved view from the actual module and created a UX page for Account Review. In the Module "Country" and "Segment" are subsidiary. I can't figure out how can I use them as a page selector in UX page. Please advise. Thanks,
-
Level 3. Sum the stretch goal% in FY
Hello, Can you please help me to find a way to have 1% in FY. If I select "Sum" in Summary section it will add up the percentages to 4%. I would like to see 1% in FY total also. Thanks,
-
3.3.5.6 Update Inventory Ordering to Calculate Shipping Costs
Hi all, I'm having difficulties with the Shipping Cost line item. I am getting an error on the formula below…Can someone kindly point me in the right direction Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP: Shipping Methods]
-
3.3.5.4 Update INV01 Inventory Ordering to Allow Override of Order Amount
Is this the correct formula? If not, please help.
-
Selected Time from another module
Hi everyone. is it possible to get the selected time from module 1 to module2 as line item.? thank you.
-
Potential Typo in 3.3.5.2D Remaining Line Items
I thought it should be "less" instead of "plus" Thoughts?
-
Date Line Item using Min Summary
Hello I am using line item formatted as date with 6 level hierarchy. I am using summary as Min for the same. I am facing issues where if there is no date in my list P6, i am getting 12/31/2399 for all NonBlank list members. Please advise best way to handle it without doing any hardcoding. Regards MO
-
Source Model and moving model between workspaces
Hi All, In one of my workspaces (Workspace1), I have two models HubModel1 and HubModel2 where some of the lists in HubModel2 are created based off saved views in HubModel1 (meaning the imports in HubModel2 are pointing to HubModel1. Say, I want to move the models to a different workspace (Workspace2). Looking for options.…
-
Mapping Native Versions to a Versions List
Is there an elegant way to map native versions to a versions list? I know we cant use SUM as this will only recognise and map the 'current version'. Therefore, is there another way?
-
How to make an export that contains the dimensions' parents in separate columns?
Hi guys! I would like to know if there is any way to create an export of a model so that the parents of the dimensions are in separate columns, for example: This is my module When I export, the table looks like this: I would like each "parent" to be a separate column, even if it repeats the information. No problem. In a…
-
Roll up when DCA applied
experts, I have an input dashboard where users input their data at base level in hierarchy. But these numbers are not aggregating at parent level. This is happening because I have a DCA applied to the module to prevent input when its locked. Question - is there a way for user input the data and also roll up when DCA is…
-
Check list at the end of the User Story?
Hi All, I came across a question, what would be the check list we should keep in mind after the user story has been completed before deploying the changes to the UAT and Prod?
-
Level3 - Redistribution Rate
Hello, Any idea why my Final Total sales target by country is slightly less than Total Initial Target? Thanks,
-
Match data between two modules that have different dimensions
Hi, I am trying to match data between two modules that have different dimensions. The target module has the following dimensions. And, the sourcing module has the following dimensions. As seen above, the only difference is the time dimension. The Sourcing module has one Time dimension, but the Target module has two Time…
-
How to convert text to date
Hi , I have a text formatted line item which is a date .I want to convert it to Date format . I tried to break it into three Year ,Month and day using Value(RIGHT(Line item,4)) Value(Mid(Line item,4,2)) Value(LEFT(line Item,2)) It works for 12/10/2012 but what about 2/3/2012 ?? Note -- Can't change source text to date…
-
Access Driver Behavior - Workspace Admin vs Regular User
I have a module X, that has two Line item Line item A which is Boolean Formatted and Line Item B which is Number formatted but has Write Access Driver set to Line item A. I have a process that Import data from Module Y to Module X. I am noticing a unique behavior depending on who is running the process on UX screen. If…
-
Question about ALM 1st time deployment
Hi everyone, When we synchronize the model for the 1st time from Development to Production(deployment), the data which is entered in modules for testing purpose in development environment( standard mode), how can we delete it in one go. It should not go to production environment(deployment). Please advise
-
SYS03 Account>Product Details, P2 Products
Hello, I am trying to load data in P2 Product line item. I am using FINDITEM(List, Text) but I am not getting any result. In my module ID and Code are in Text format but they didn't work. I created DAT03 module to turn P2 Product list to Text and referred to DATA03 in the formula but still didn't populate the data. What am…
-
Dev and PROD desynced following a backup restoration
Hello Everyone, I have taken over the Workspace Administrator responsibilities within the business and I am still learning about the basic model maintenance tasks. We've had a deployed PROD model synced with a DEV model to sync any structural changes and using revision tags. Recently, I have taken a copy of a PROD model…