-
How to converte a Date to a text
Hello, I am trying to convert a date (Line Item "DLC DATE") to text (Line Item "DLC DATE TEXTE") using this formula: TEXT(DAY('DLC DATE 2'), "00") & "/" & TEXT(MONTH('DLC DATE 2'), "00") & "/" & TEXT(YEAR('DLC DATE 2'), "0000") However, I don't get the correct values for the month or day when the value is under 10. For…
-
L2 Model Building - Sprint 3 - confirmed PO delivery
I am stuck with building the formula for "confirmed PO delivery" In case line item "PO submitted" is 1 for week x, it should show 1 in line item "confirmed PO delivery" for week x + offset. The offset number is depending on the shipping time shown in week 1. I used formula: IF PO Submitted = 1 THEN OFFSET(PO Submitted,…
-
How to get value from time dimensioned module to non-time?
Hello, I have a module DEM03.1 Mapping (CV&ADI) with Time dimension and LIST03 SKU with the same List but without time. I'd like to get first non blank value from Date of introduction Line Item in DEM03.1 (1 pic) to Date of Introducton in LIST03 SKU (Pic 2). How can I do it?
-
o
one of my friend wants to learn anaplan through self paced learning, he is not able to find the option to create account, kindly help
-
Order in SUM agregation parameters for performance
Hi hive mind, I have a tricky question. Here we go : I have a target module with 3 custom dimension (A,B,C) + Time (Month) I have a source transaction module containing line Items with A, B, C list formarted and a date column and an amount column In my Target Module, I need to agregate the Source amount with A,B,C and…
-
年度リスト→日データに適用
4月~3月を一つの年度として、認識させたい。 まず、年度のリストを作りました。(2024.2025…. そのリストを、日データ（2024/4/1→2024）につけたいです。 年度算出まではできたのですが、その後どうすればいいか詰まってしまいました。。
-
Anaplan Connect Chunk Splitting
When importing/exporting data using Anaplan Connect 3.0, if the file is 100MB or larger, it will be split into chunks according to the chunk size setting. When this happens, if the file contains multibyte characters such as Japanese, the characters will become garbled. Does anyone know how to solve this problem? Or will…
-
アプリ表でのフィルタを合計に反映
アプリ上での表でのフィルタを、合計に反映することはできますか？
-
New UX: Make features in 'Board' and 'Worksheet' page layouts consistent or give blank page layout
Hello Anaplanners, While I really like the option of choosing either a 'Board' or 'Worksheet' style for creating pages/ dashboards in the anaplan UX app, there are certain limitations that could be possibly enhanced. I have been leveraging new UX capabilities for multiple reporting purposes in my current project. The…
-
Women’s History Month: Spotlighting leaders in the Anaplan Community
March is Women’s History Month, a time to celebrate the achievements and contributions of women — including the incredible members in the Anaplan Community! Over the past year, women across the ecosystem have shared their knowledge, experiences, and insights through blogs, videos, and member spotlights. Their expertise…
-
Anaplan XL : How to writeback
Hello, I would like to know how to Input data from Anaplan XL to Anaplan, the lesson about it only refer to Fluence and not Anaplan … Thanks
-
L2 - Spring 2 - 2.3.8.4 Create DEM02 Volume Growth Rates by Week module
Add a formula to the Growth % line item to convert the DEM01 Volume Growth Rates.Growth % (monthly) value to weeks For this task, I have applied the formula WEEKVALUE('DEM01 Volume Growth Rates'.Growth %) but this formula seems to be incorrect. The values in the weekly columns are 0 instead of monthly value/no of weeks in…
-
Access to Coplanner in any Application
I have completed the Coplanner training on Anaplan Academy and would like to practice this functionality. Is Anaplan Coplanner accessible in any demo application? If so, could you specify where? Does it require activation/special request at the tenant level within the organization? How does it work?
-
Not able to fetch the history for particular cell
Hey People, Does anybody know why I am not able to fetch the history for particular cell, or has anybody faced similar issue. Ss below even after using the 'Export' option, text file is blank. Any inputs ?
-
Question about Boolean line items
Scenario My rows include 3 items - REC1, REC2, and REC3 my columns include quarters - Q1FY25, Q2FY25, Q3FY25 and Q3FY25 Line item - 'Select' which is formatted as Boolean. Desired Output - If I check any one Boolean among REC1, REC2 and REC3 for a particular quarter, the remaining two rows should automatically be disabled.…
-
Give us the ability to rename the default title "Additional Insights" in Worksheet side panel.
We sometimes use the side panel for data entry, and the title "Additional Insights" may not always align with our use case. It would be helpful to have the flexibility to change the title to something more relevant to the panel's purpose.
-
Export Formats
Hi, Just wanted to know that while exporting from the New UX is there any way in which the pdf export format be obtained as an A3 page. Currently the export is landscape oriented by default so is there any way out that this can be changed. Thanks in advance!
-
Need to create a form for users to fill out and the resulting data logged with several requirements
Objective: To create a reusable "data entry form" that allows users to Create a 'Project' The form requirements are as follows: Project Name, text Project Description, text Estimated Funding Cost, number - currency Projected ROI, number - currency Projected ROI (%), number - percentage Funding Required by - Date, date VP…
-
Dynamic Average Calculation
I want to create a functionality where the end user will select a start and end month from a pick list and based upon the difference in months Anaplan will calculate the average revenue. Revenue data is already available in the module in one of the line item. Can this be achieved through MOVINGSUM() ? If yes, how do it…
-
Preventing Duplicate Imports and Handling Data Changes
Hi ALL, I have an input module where users enter project input details such as Project, Country, Size etc..These two modules are connected through Project 'Libe'. Users uses a Boolean called 'Import to L2 Page' to import these records to the 'L2 ' page using an action. After the import, the Boolean('Import to L2 page) is…
-
NUX - Add several entries at one time in a module dimensioned on a list
Hi in the classic interface, when a module is dimensioned on a list, it's easy to add several entries at the same time with the action of creating items as showed below (which eases also the fact to copy-paste information which can be the same on several lines created): In the NUX, it seems that the only way is to create a…
-
Variance reporting - not using native versions
Just to give context we do not use the native versions in Anaplan, rather we use a list name forecast versions and then have a subset of these that we have of these that are marked as those we wish to do variances on, which seems to work well. We predominantly look at variances at a certain level in our cost centre…
-
how to place the total full year on the chart using the Classic DB?
just a simple question on how can I place the FY25 total also in below chart? I always included the FY25 in my module when I created the chart but it is not appearing.
-
LOOKUP Problem!!!
Hello community, I am going through something with Lookup formula as below. I have a module (say module1) dimensionalised by Account list with Account code column. I also have a List (say list1) with account code, employee code and names. In the module 1, I have created line items for employee code and name. For which I am…
-
Anaplan's "Fair Use Policy" - Clarification needed?
I was going through Anaplan's "Fair Use Policy", which I believe will come into effect with the new Licensing model. Anaplan is intending to simply the workspace allowance slabs and framework through this, I've a question on a specific statement from the policy page. "To uphold the quality of the Anaplan Service for all…
-
Dynamic Subtotalling for List item subset based on user selection - Module Size Optimization
Hello, Apologies for the long post, I tried to be descriptive enough! I've a module in production which has close to ~3 billion cells, (this module alone occupies 25GB of space). I'm trying to optimise this module for space and make it scalable. The reason for the size **** up is multidimensionality and extreme sparsity of…
-
Cloudwork export don't include the time stamp
Is there a way i could exclude the time stamp? i basically don't want anything that's from _January until 034607. Thanks.
-
Actions - New action 'Bulk Copy" - Select the source and target list items when the action is run
Hey Community! Could you please explain the function Actions - New action 'Bulk Copy" - Select the source and target list items when the action is run? This option is open when you just open the modal window to select source and target, as well as after manual selection from the list of all actions. Many Thanks Many Thanks
-
ANAPLANXL WRITEBACK
When I am enabling the writeback in AnaplanXL and trying to format the written cell to some colour, it is not showing me in the main sheet where I am trying to input some value and the cell colour is not changing. What could be possible reason for this?
-
What are the common and Major/complex issues that we face while implementing FP&A projects
Hello Forum, Could someone please help me with one of the question that I have. I worked on FP&A enhancement projects whereas not the E2E implementation. What are the common and Major/Complex (Functional/Technical) issues that we mostly face while implementing FP&A projects with Anaplan. Also what are the most commonly…