-
Define current year end week
Hi all, How can i define CY end week by formula not hardcode. we dont want to use CY week +52 so any Suggestions
-
Model Map - export as a file e.g. image e.g. .jpg
for complex model maps; the ability to export these as images is really useful; for documentations. Especially parts of complex model maps.
-
Level 2
Hi,
-
Apps > Report: Add Variance between rows
The new feature in Apps > Report to add variance between columns (as shows in the screenshot) is fantastic. It would be very useful to have the same feature to calculate variances between rows, but this is currently unavailable. It would be greatly appreciated if this feature could please be added as soon as possible so we…
-
create a home page in Anaplan with navigation buttons
Hi all !! Is it possible to create a home page in Anaplan with navigation buttons? If it is, could you please provide instructions on how to accomplish this? Thank you.
-
2.4.4 Activity: Update Demand Forecast
The problem i facing is i am not getting current Baseline Forecast for FY21 and i am attaching three screenshots for the same of the formula that i have used. Please someone help me this problem, i have been stuck for two days. I am getting Week 1 FY21 =60.64 but they are getting Week1FY21= 59.47
-
I want Booleans as true as per below requirement
-
Source Label change with change in model in Imports.
Hi, I have a model - Model 1. I took a copy of the Model 1 and named it Model 2. Now in the Import section of Model 2, the source label has still the name Model 1 in it. So, wanted to know when we run the action will it be from the same model Model 2 or it will be from Model 1 from where I copied it. Thanks.
-
2.3.10 Activity: Create Demand Forecast_unable to see FY21 data
Hi, As per process I have created DEM03 Demand Forecast Module. It shows FY20 data but FY21 data is missing in the data. Could anyone please assist me If I am wrong anywhere. Please refer below screenshots. required output- I got below output -
-
3.4.3 Activity: Create Country Summary Module
I have created the module as requested and added below formula, however there is no data reflecting in my INV02. Can anyone suggest where i am going wrong? SYS08 module snip INV02 module formula INV01 snip where my stockcount is shown as 0 completely. INV02 is shown as 0, not sure of error. Kindly let me know, thanks for…
-
Summary Method Issue
Hi Community, I'll try to put this in excel to describe my problem better. To explain the excel better, I have Region and Status title at page selctors, I have line items in column and Org L1 at Rows. Now Line item 1 already has a formula and its summary method is formula too. In line item 2, I want sum of only positives…
-
Moving Average Issue
Hi, For my Forecast Jan 2023 I want to bring the (Actuals) AVERAGE of Jan 2021 and Jan 2022. And for my Feb 2023 I want the AVERAGE of Feb 2021 and Feb 2022, e.t.c. To achieve this I split the line item actuals values into the ones below, for calculation and then bring it to the forecast. for 2021 Values line item for 2022…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
please any one help to solve this activity .I n mapping i am not getting P3 SKU values so data is not importing
-
SUM IF Anaplan
hi there, I would like to build a report which would basically be a P&L where I display the cost per segment in 1 table. My segments being a grouping of a list (departments): my "base" P&L looks like that: and the report I would like to build should look like that: The idea would be to fill in the cost lines (Human…
-
NUX - Vertical lines in designer view
For page builders it would be great to also have horizontal grid lines in the pages designer view. This would help to align the size of the cards not only in the width but also in height. This is especially helpful if you have a page with multiple text cards that are functioning as links to pages, or headers.
-
Level 1 Model Building - Exam
Hello, How many attempts are allowed to pass the Level 1 Model Building - Exam if we did clear in 1st attempt. Regards Shashank Gupta
-
Create DEM03 Demand Forecast Module
I am really stuck with the formula to be used in this module. Would really appreciate help if someone can guide through detailed formula
-
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…
-
Training procedure
I m confused to understand the method of training as till now portal is only updated with written content . Will we get video session or this is only content with which we have to move on .
-
Get Maximum number against year in a transaction data?
Hi, I have transaction data where i have a period formatted line item with the year and a number formatted line item called Number. I want the maximum number against each year in the Max column. I tried the Number[MAX:Year] but it didn't work. So how can I get the maximum number against each Year? Attaching the screnshot…
-
Can Data Hub hold formula related data? or just the spoke model is supposed to that?
-
Variance Report Issue
Hi All, I am creating a variance report using a custom list mapping to a native list in order to bring the data to the module with fake list. After I sum it I noticed the Actuals data is not flowing in the actuals for the target module but in one of the version only, And other versions afre not flowing to the target…
-
Auto refresh when apply filter and sync the rows in New UX
This is one of the major issues, In this the data is getting auto filtered for an instance User filtered based on employee name and as the updated the territory with another employee name it gets filtered out immediately as we click on the another row to update other changes. This auto filtering was not there in classic…
-
Filter Option on New Ux displaying complete list data when limited items are published on dashboards
When we apply filter on new ux it displays us with the complete list of items to be selected instead the ones showing on the dashboard. Also when we apply one filter on one column and try to apply another filter on the second one still it displays with the entire list instead of the limited items that got filtered out…
-
Ability to Limit End User Module Options
The NUX doesn't allow us to limit what end users have the ability to do like the Classic does. The option to Show History is a non-negotiable need to have in NUX before we can fully transition over from classic. Our largest model contains quite a bit of data and has 1k+ users interacting with it throughout the day / week.…
-
How to Use DCA to deactivate boolean selection?
Hi Community I have 2 list. List A & List B. I have created one module using list A and there are two line items Product Family (Formated as list B) and Applicable?(Boolean). I have to disbale boolean if I select Appliacble aginst other list item if I select A(Other A should be not accessible) while I can tick boolean of…
-
Error Pop up for Ignored Mappings(Subset List)
It would be great if we have the functionality as below. Current functionality: When importing a sku volumes and in the SKU list SKU1 is not there we get an error saying "Item not located in SKU list". Similar functionality as above for , example if we have subset of SKU list(SS SKU list) and the SKU1 is present in SKU…
-
Boolean Processing Optimization
I had heard that removing IF THEN ELSE from boolean formulas is more efficient. For example: a = 1 AND b = 2 is better than: IF a =1 THEN IF b =2 THEN TRUE ELSE FALSE The reasoning I was given was that Anaplan will process conditions a and b in parallel for the first formula, but sequentially for the second. Is this true?
-
Can we disable Create page button from the UX for the end user?
Hi, I want to disable the create page button for the end user from the dashboard. Please let me know, if there any way to restrict it?
-
Management Reporting Example