-
Formula to sum with condition
Hi, I need to sum the elements of one column based on an element "text" of another column. This text element isn't in a list so I can't use the function "Select". What formula can I use ? Thanks ! Best regards
-
3.3.5.2 Inventory Ordering Module Formulas - Beginning Inventory issue
I am getting the formula right - IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory However, I am not getting the desired results. I am getting IF and THEN part correct but i am not getting ELSE part correctly i.e., ELSE…
-
Timestamp using data write action
It would be nice to have it displayed the action run time stamp or a Boolean check timestamp using a data write action in New UX. we can bring by text formatted line item as we dont have time stamp data type. it will help to calculate several time related calculations. which will definitely help in several use cases.
-
3.4.3 Activity: Create Country Summary Module
Hello, This is my proposed formula for the Flag Count line item - taking into account the mapping for both country and product family that are dimensions in the INV02 module 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In, SUM: 'SYS08 SKU Details'.Product Family] When…
-
stuck on level 2 sprint 3.3 activity
hello i need help, please !!! I am stuck on level 2 sprint 3.3 activities I don't understand why i can't have the same results that course My results My formulas Level screen reference
-
Accuracy of calculations
Hello everyone 🙂 , we have two model builders who applied the same formula but with a different order, but since it's multiplication and division, the order doesn't matter. Unfortunately, I come across two different numbers. How accurate is Anaplan in calculations? Here an article i found Precision differences and large…
-
Distinct count of Agent with comparing Date and Program
I have Module in DataHub without any Dimension I need to create a column that count distinct (Unique) Value of Agent Program and Agent are in Text Format DateProgram Agent Distinct Agent…
-
List property formula functionality to match module line item functionality
Hi Anaplan! It would be great if when you are entering a formula within a list property/attribute you can select another list item property by clicking on it instead of having to enter the name each time. This would also need to apply when referencing a modules line item, so clicking on the line item when a formula is…
-
NPV Calculations
is there a way to calculation the NPV on a rolling basis? So basically I would want the NPV to be calculated on a quarterly basis for the current quarter and forecasted quarters. per the screenshot below, for Q4 2019, i want the NPV from the current quarter to Q2 21.
-
Version Formula in Module
Hi, Is there a step by step guide on how to use the Add version formulas to line item subsets in module blueprint ? I don't see any line item in the left box. Thanks, Tom
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi - I'm sorry, I'm really sure sure what the section is asking me to do?
-
Error Message
Hi, I have an error message that keeps on popping up when I'm trying to create a formula. I'm trying to multiply the two line items together. Please advice. Image is attached. Thank you
-
Time Spread (Reverse Count from point in time)
Hi, I have a problem I am finding difficult to solve. Hopefully, someone in the community has encountered this before and can provide some clever solutions to this. First of all, the modules I am showing here are just to explain the problem I am trying to solve. The actual modules are on a very large data set so I need to…
-
L2 2.3.10 Wrong Value
Hi - I am at the L2 training segment 2.3.10. While my formulas are all correct (I think), I am somehow still seeing an unexpected value as an answer. Screenshots below on my formulas. I'm not really sure what's wrong here. Any help?
-
Formula
Hello, Quick question: How can I calculate the Volume between FY17 and F21 in the other module? For example, the difference between two years. Note: Just Volume is a line item. Please see the attached. Thanks, Mark
-
Behaviour of SEQUENTIAL parameter in RANK function
Hi All, We have a requirement to sequence items in a export and we've been using the RANK function to achieve that in a similar way that is listed in several posts in the community…
-
Create Demand Export Module and Create a Saved View - DEM04
Hi, I am trying to do this activity: Here is what I did for DEM04: And this is my export view: There are two problem comparing with the expected result 1. The SKU Code and Location Codes does not appear in my saved view.( I put all line items as column) 2.The Demand amounts are not correct, here is the expected view: I…
-
Level 1 Lesson 4.6.9 File Mapping Guide
Hi Everyone My import was successful however it doesn't match the guide Here's the result of my mapping Here's the guide Hope to hear from everyone soon!
-
LEVEL 1 EXAM MODEL BUILDER ACTIVITY 5
Hello everybody. i´ve been stuck in this activity since yesterday, a create a Role list, With a top level of all roles, then i import the new data in the SY08 EMPLOYEE DETAILS with the extra role line and i don´t get any issue with the data. The thing is that when i try to change my formula for the BONUS, CAR COSTS, PHONE…
-
Trying to filter by a Yearvalue with a nested Lookup to pull list parent
I have a module that we export data from using two system type modules that allow a user to filter their export by version and by year (time) using boolean selection boxes (checkboxes). I want to add the ability to filter by a third category, Division. The way the module is currently filtering the data in the export action…
-
Profile Function for Revenue Recognition
Hi everyone, My company uses Anaplan for all budgeting and forecasting and we recently discovered an issues as this is only our second year. We have 2 metrics "Bookings" which are sales associated with contracted revenue, and "Installs" which are when the booking begins being recognized as revenue (as the product is…
-
POST formula in SPRINT 3
Hello, Can someone help me to understand why for "Confirm Purchase Order Receipt" line Item, "POST(IF NOT Submit Purchase Order Request? THEN 0 ELSE Final Shipment Amount, Final Shipping Time Weeks) " is not a correct answer for the formula to use? Regards
-
Restriction line item based on another line item
HI all, I have a module Fnem00, here we have to Select the Account and program. Based on that we have provided the DCA to enter the values in Fnem01. Now if I delete the Account and program in Fnem00 the Values in Fnem01 is Values are not getting erased. How can i fix this?
-
How to keep the input value after switchover
Hi All, i have a question about switchover Currently the forecast period is started from Jan 23 and i have input a $10 in this period however after i have switchover to Feb 23, the input value will gone. how can i resolve this issue? thanks Before switchover After switchover Blueprint
-
Anaplan natural rollup is not equal to sum of values from its children
Hi, fellow Anaplaners I observed some weird behaviour of Anaplan natural rollup (meaning set line item as number & sum as summary method, then parent item will take sum of all its children's values). I have 2 line items here: 1. Commercial input is number formatted; no formula, is for planners to manual input forecast…
-
Improved Formula Editor/Bar
If the following features could be added to the formula bar in Anaplan it would make model building and maintenance a lot easier! * Colour coded statements and keywords (e.g. IF THEN ELSE, line items, constants) * Ability to indent and enter new lines. Particularly useful for IF statements * Keyword autocompletion *…
-
Activity 8.8.2
Hi, I am unable to add the right data in Fy 21 and FY 20 in the REP 01 Country Margin Report Module. I have added the exact formula as well but it is showing the correct answer in only the FY 19 rest two years are incorrect. I have check my other modules i.e., the referring module for this formula is also correct but the…
-
UX dashboard filter not defaulting to current user
In an attempt to reduce the size of a line item(used for dashboard filtering), we created a dummy list that contains a small subset of people. The subset of people has selective access enabled. I then used FINDITEM to link the Users list to the subset. The linking worked successfully. However I ran into an issue when I…
-
Which approach is better? (Related to Text, Lists and Formulas)
Hi Everyone, I have a module which is dimensioned by one list. It has around 60k items. In this module there is one line item (Main_Text). I want to pull a string from this Main_Text line item and then use Finditem() function over that string. Right now, the approach that I am using is to calculate them in two different…
-
Size of model increase.
Hi All. I have a Prod model. which has been gone live Aug-22. Now its size increasing every month. Our Total Model size 200 GB .Last month we had 160 GB this month its increase 176 gb. Now its occupency is above 80% .now we want to incease workspace. Now, i want to know how much space should i purchase. What are the…