Friends need your help !! I am trying to optimize the model with the help of cross-references so that can remove most of the formulas from the model (multiple modules will be optimized if successful).…
Hi Community, I would like to ask some guidance and idea from you guys. I have an input module: Problem: How can I keep FY 19 FY20, FY21 and FY22 inputable while FY 23 to DY 26 will be calculated. Is …
Spoiler (Highlight to read)I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?I have monthly date as Jul 2…
Hi All, I am working on a stock rationalization logic where I have Orders as dimension and have to see how the SKUs will get distributed as per the requirements. Attached is a case representing the lo…
Dear All, I just feel nervous when it comes to making formulas. I don't know how to get rid of this and be confident about making formulas. Can anyone please guide me how to create formulas easily and…
Hi, I'm trying to create a formula that will output the date based on a TRUE/Checked Boolean. We are looking to be able to bring in the date for the Line Item '10th of the Month' based off of the Bool…
Hi, My organization recently has gone through a re-org and as a result, our employee hierarchy has changed from 3 level (VP, director and manager) to 4 levels (CDO, VP, Director, manager). We used to …
It would be useful to be able to export the Actions contained in a Process. Currently the only way to extract them is to highlight them all copy and paste into Excel. Add a column numbering 1 to x and…
Hi Team, I am having trouble in Calendar Setup, I need a 4-5-4 Setup and my Current Fiscal Year is (FY21 :26 Sep 2020 - 24 Sep 2021). This Setup works fine for FY21 & FY23 as it's 52 Weeks but for FY2…
I believe I have uploaded the EMP02 Employee Expenses and EMP03 Employee Drivers by Role correctly but when I go to change the formulas in EMP02 Employee Expenses for Bonus etc. I receive an error. IF…
Hello, I need to write a formula to taka data from one module, but only for current month. I can not use LOOKUP function, because dimension doesn't match. e.g. When the formula includes selecting a sp…
I feel like my formula is correct but for some reason I am only seeing zeroes as values in the DEM03 Demand Forecast module. Is this an issue with the DATA03 Historic Volumes module? To my understandi…
My requirement is to create numbered list and to restrict user to enter duplicate values for display name property. Please assist how can I achieve this functionality?
hello guys, i have this module dimensionned by a list. The list is made from differents families and the row axis is made of many lines item and whenever an element is added by the user it insert itse…
Update: Thanks to the community. I have completed and passed the Level 1 test. I think I entered the correct formula for editing the formula, but I am getting the error above. I think I get it that th…
hi guys, i would like to know how i can do this in anaplan ( image). i have a module dimensionned by one list. the module is published in the new ux as a worksheet filled by the end users using a form…
Please help. I am Missing data in the forecast version of the REP03 module and cannot figure this out. I feel like I've checked everything three times, and don't know why the data isn't populating.
Hello all, My team is working on breaking apart a particularly complicated SUM/LOOKUP formula that was built 4 years ago. Looking for guidance anyone may have out there. Here's what the scenario is: -…
Hello, I am struggling to figure out how to distinguish the usage between SUM function and LOOKUP function. Could anyone explain the meaning of the "list-formatted" such as list-formatted line item/pr…
For some reason I can't figure out the formula set up for questions 3 & 4 bonus and phone costs by role. I am wondering if my references are mismatched. Any help on this is appreciated as I feel like …
In order to support varied testing and especially split-model deployments (same dev model with different data sets/time periods), it would be useful to have Time Ranges be Production Data. This will p…
Hi all, First time posting to Anaplan community, I'm hoping this is a task that can be automated by Anaplan, just another one of those time-saving features that would be perfect to be built into a mod…
I searched for the posts regarding zeroes vs null values but don't think I found an answer to my question. So in module A, when people create projects they input values. These values are brought to mo…
