Anaplan Community

Boolean Automate
Is it possible to make the boolean automatically uncheck itself based on date provided from another/same module? For e.g. In the picture, date is set to be 7/18/2024. How to make Q1 FY24 uncheck and let others stay checked?
Is it possible to have a chart with a dropdown selection to show either weeks, months, quarters?
For example, if I have sales numbers w.r.t to time, however I want a single chart on front end that has a dropdown selection to switch between lets say 6 weeks, 6 months, 6 quarters as 3 options, how can we achieve that?
8.6.4 Activity: REV03 Margin Calculation Error
I am working on activity 8.6.4 Activity: Add Formulas to Margin Calculation Module I have some different numbers to what are there in the screenshot shared in the lesson after Check Your Work. Can someone guide me on what I am doing wrong I am attaching my numbers screenshot of what I get for output and the blueprint view.
REP02 Size Margin Report
Hi, I am trying to put the formula in the REP02 Size Margin Report module which is part of 8.8.4 Activity: Add Formulas to Size Margin Report Module. However, while entering the formula I am getting an error. Could someone help me with the same?
2.3.10 Activity: Create Demand Forecast
Hi, I am stuck with creating formula for Baseline forecast, I have used formula "IF NOT 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN LAG(Default Forecast, 52, 0, STRICT) ELSE 'DAT03 Historic Volumes'.'Offset Volumes for 1st Forecast Year' But it only seem to work for FY20, I dont see data for FY21. Can somebody…
9.2 Model Build Specifications (I do not see the values being populated quarterly)
Can someone guide why this is happening?
Minesweeper: How we Built it?
Do you remember the good old days when we used to play games like Solitaire, Minesweeper, Pin Ball, Checkers, etc in your big and bulgy desktop? Oh! Those were the golden times of youth, even though we cannot match the high-end technological development in graphics, storyline, real life game play, regular updates but the…
Facing issue in column separator
Hi everyone, In the source we are using pipe to separate the columns .In anaplan i have created action using .csv file and now changing the column separator from import data source ans using "|" instead of column. For some data element this is working fine but in few in module i dont see any data. also when open the action…
Time is missing as Context Selector
I am actually building a UX page following the instructions given in 3.4.4 Activity in which I create grids from saved views, but Time is missing as context selector on the top right corner which end user should be able to filter. PS: there's not filter applied in the grid nor the saved module views Could anyone advise…
Need to know if we can take out some GB from 1 workspace and put that space into different workspace
Hi, I have a question where I want to split out like 30 GB from one of my workspace and put that 30 GB into different workspace. Current Situation Workspace 1= 130 GB Workspace 2= 300 GB Required Situation Workspace 1 = 160 GB Workspace 2= 270 GB If its possible how can we do this. Thanks
Driver Line Item for Action Button
I have condition in card where user can input negative value. But when the value is negative, the button will disable to click. I have data Product as Context Selector, Time Period Month in Column, and Line Item to input Order Quantity Review in Row. User will input number of order quantity review, but when the value is…
HELP IN IMPORTING DATA
Look when i am importing weekly data in my INV01 when i want to map time with column headers Time (2019-12-29 - 2020-01-04, 2020-01-05 - 2020-01-11, 2020-01-12 - 2020-01-18, ...) this shows up but data in my 'csv' and 'inv' in form of WEEK 1 FY20 but in mapping dialog it shows Time (2019-12-29 - 2020-01-04, 2020-01-05 -…
3.3.5.4 I AM CONFUSED,
Please Help I am not able to understand what we have to do in this particular section Here are my queries 1)The formula hint shows IF/THEN condition and then it says The next condition is override suggested amount? line item, so do I have to nest both the conditions ?? Please let me know 2)Also it says Update another line…
Introducing our new Community Boss Employees program!
We are pleased to announce the launch of our Community Boss Employees program! In 2023, we rolled out our re-imagined Community Boss program to hand-selected customer and partner Community advocates. This year, we are excited to expand the program by including a select group of exceptional Anaplan employees. These…
Excluding Ticked Booleans
Within a list, is it possible to create a list subset based out of formula to exclude ticked booleans from other list subset of the same list?
Inquiry Regarding Anaplan Integration Process and Schedule
I have created an 3 Integration Process and added it to the Integration Flow and Schedule using my ID. I have a couple of questions regarding this setup: If the update schedule is modified using a different ID, will the process continue to run under my name, or will it reflect the name associated with the new ID? In the…
Text format validation
I would like validation functionality for text formats in Anaplan. When entering names of products or items in Anaplan and importing them into external systems, import errors occur if the input contains strings that the external system cannot import. Having text input validation functionality in Anaplan would facilitate…
Level 2 Spring 2 2.3.10 Baseline Forecast
I believe the problem has to do with my time range, but my 2nd year forecast isn't populating anything. This is my baseline Forecast formula: IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) ELSE OFFSET(Baseline Forecast, -52, 0) The time range is fy19-fy20 to…
Import is zeroing out a field that it shouldn't be
Hi team, Got one that for the life of me I cannot solve. I import the below file and the numbers load as intended. You can see the imported numbers below and the mapping from the import The trouble I run into is when I run a second import. looking at the data im importing, there is no line going to CC 3602 and GL 65566,…
Excel Add-in for Anaplan
Hello, We have been planning to incorporate excel add-in for a finance use case, and would like to take experiences of others using excel add-in. More specifically, we would like to hear and learn how excel add-in is beneficial for your team (does excel add-in facilitated collaboration or improvements in managing Anaplan…
How to enable Override? button for end users and allow them to enter the Override Forecast Value?
I am not able to enable the Override? button for selection and neither I am able to enable the manually enter the Override forecast value for the end user, hence please help me get both of them enabled for the end user.
Graph time selection?
Hello, I have a table and a graph based on a table. The selection that I have in Years, Quarters and Month. The Table should move on every selection of Year, Quarter or Month but the Graph I just want to stay only on the year selection. So my graph should show all the month of the year regardless of the selection of the…
How to create in a module a quarter option?
Hello, I have a forecast module, with monthly TimeScale and I want to create, in this module, an option for a quarterly view. So basicly, if the client wants to see the data quarterly, he should be able. I also have a MOD02 Quarter Time Settings and also a filter module for the quarter part. At this moment, my data is…
Impact of model archival on Cloudworks
Hi all, I had to archive the production model, and when I restored it to deployed mode, I've noticed that the connection to Azure scheduled for last night didn't work (I had it rescheduled but it failed). The status is set to "auto deactivated", however if I manually run the processes, they are successful. I have…
Workflow Notifications
Hello! I'm currently building out a workflow template using the new workflow feature. However, when I kickoff the workflow I receive about 10-15 emails. Is there a way to control the notifications that are sent to the end users? Thanks!
Snapshot Challenge with #list
My scenario today, Integration runs everyday and clear the below numbered list with data. Since the build has been done without the code i'm struggling to create the code with unique combination. My objective is : I want to copy the current data before the delete process will execute. and compare it against the data that…
Conditional Formatting Help
Hi All, Checking the possibility of conditional formatting for FY 24 -GAP as shown below. I don't want the BP or Fcst to be formatted. 2. Is it possible to extend the Color formatting to only certain line items label (like net revenue, GM and GM %) needs color formatting 3. Is it possible to have spacing between Forecast…
Including Text within a Number Formatted Line Item?
Our client requests to see "no MTA" when MTA= 0 and Warehouse <> 0. However, instead of 'no MTA', I'm getting 'NaN'. Is it possible to include text within a number formatted line item? Formula - Final MTA = IF MTA = 0 AND Warehouse <> 0 THEN VALUE("No MTA") ELSE MTA
Anaplan Model Back Up Automation -[Copy and Archive] process
Considering that the Copy & Archive feature under Manage Models in Anaplan can copy and archive a model without impacting storage size limits. How can I implement an automated daily backup solution for Anaplan model data, given that there is currently no in-built scheduling feature for the Copy & Archive ? My clients…
2.4.7.1 conditional formatting add new rule option is not avaliable
Hello Can i know why I cant able to apply conditional formatting? why there is no new rule icon available when i select conditional formatting icon ? I have selected even a line item row or column and selected conditional formarting icon but still i there is no New rule option avaliable

Anaplan Community

Discussion List