-
Delete data from Numbered List No parents
I created a module and process to delete all the data from Numbered list. it works fine to delete the data however there are some data (no parents, just code) which I am not sure how those got into the list are still there(I believe because of the mapping eror). Also, on the delete module, these data dont show up but those…
-
How to Truncate the combination of string and numerical?
In a module, a line item is list formatted and the data displayed is in the form "String1:String2 Numerical code". How to truncate the data and display the string1 only in the same line item? Example: "ABCD:efgh 12345" (say) is displayed in the list formatted line item. Then, how to display only ABCD in the same line item?
-
What are these fiunctions for?: HALFYEARVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE
Can anyone tell me what these functions are for? I have read Anapedia but still having a hard time understanding what they do. MONTHVALUE HALFYEARVALUE QUARTERVALUE WEEKVALUE YEARVALUE In the sample below, I guess that "each weekly sales" are compared to "average weekly sales." And it turns out to be "True" if a weekly…
-
level 1 exam activity 2
Question: In the Level 1 model, update the REV02 Volume Inputs Module to include a formula to pull data from the DATA02 SKU Volumes module Not getting what exactly i have to do in the attachment shared a screenshot of error
-
Totals (across a list) without a parent member
I have a module that is dimensionalized by row ID (#1-#n), no parent member for that list. It is an input template to model new expenses. What I am aiming to do is to have another line item (could be in a different module if needed) that will look to see if any of the rows have data. Essentially each row has line items…
-
Time period check box
hi! When I tick a checkbox for a year, I want that month to be displayed in full. I think it's simple, but I can't do it. Please help me.
-
Serial Numbers in Anaplan
Hi All, I have a module with a subset of numbered list applied in its dimension. We want to derive the S.No/ Count of Items in the list in a line item in the module eg: If the list has 3 items A,B,C in the mentioned sequence itself then corresponding to A in the line item built we need 1 then corresponding to B we need 2…
-
Update List Property
Hi, I have been trying to update property in a list from a module with different dimension. Can anyone assist please?
-
ISACTUALVERSION - correct Output
Here's the official documentation on the formula - https://help.anaplan.com/138ee6b0-34a3-4654-b944-f655e6b28ad8-ISACTUALVERSION As per the article, ISACTUALVERSION returns TRUE for Actual Version and FALSE for all other Versions. However, I observed that the actual output is different when you use Time as a Dimension.…
-
Date Formats - Month Name/Text from Date
Hi, Does anyone know of a function that I can use to format a date in a specific manner. Bringing in month names instead of numbers. e.g. From 1/1/2014 I want 'Jan 14' as text In excel I would the text function - TEXT(*date*,"MMM YY") Thanks, Simon
-
Level 1 Activity 9.2.6 add formula to Margin calculation Module- Cost of Sales
Hi I am on learning level 1 activity 9.2.6 of Anaplan. I am struggling to insert the right formula for cost of sales formula as per training module is : Cost of Sales'REV02 Volume Inputs'.Volumes * 'REV01 Price Book'.Unit Cost * (1 + Unit Cost Growth %) All the other formulas are working well. I also tried to write the…
-
Conditional Formatting rule Inputted by user
Hi Guys, I just want to ask something. Now in the conditional formatting screen we have the range of MIN MID and MAX right as the basis for the color of the cells in Anaplan. Is there a way where the user will be the one to input the threshold (is the term we use in the model) or the MIN MID and MAX. in my example below I…
-
Workspace access
Hi, I am unable to login to workspace and can anyone please assist me on the same. Akshay Mail I'd:- akshayanaplan@gmail.com
-
Best Practise Recommendation
HIya, I am currently pulling various modules out from a large model to provide better user security, I then plan to pull the data from the top level module back into the main business model. Is this something you recommend doing via a monthly import?
-
Time filter for current FY
Hi, I have an issue related to time filters. I have a module dedicated to time filter which I use for my other modules to show the relevant years/months. My fiscal year is from jun-may, and I want a filter showing only the current FY, that is from jun 2021-may 2022. I hence want to have booleans ticked for those months but…
-
List Subset
Does Anaplan treat List Subset as a different List? Because when we changed a module dimension from "Product list" to a subset of "Salable Product list", all the filters got removed.
-
Can you pull line items into a modual from USERS list, fore example First Name, Model Role?
I am trying to set up some dynamic access within a model using read / write access drivers within certain moduales. I plan to do this by setting up a modual to set the access at user level using the user list as one of planning keys, but would be good if could pull in the assigned Roles, first and last name as would mean i…
-
Conditional Formatting on Parent Level only
Hi, I've been building a module with a list composed of several children and one parent. The children can be associated with positive or negative numbers (rate of change). As a parent, the amount associated to it is the sum of all its children. I'd like to add conditional format ONLY to the parent to check whether the…
-
Level 2 Sprint 3 Safety Stock Exception DB
Hi Team, @Misbah @einas.ibrahim I am Struggling with the data not auto refreshed in Safety stock exception DB. eg. If I select FY21 page selector then it is not auto-refreshing the data and even when I refreshed it manually then also I am seeing FY20 data. I have made show selection in my INV02 module for months as in…
-
Summing a line item based on time period in another line item
I'm attempting to come up with a total amount per period. However, the module I'm working with is not dimensioned. I have a month formatted line item called 'Period' and am hoping to sum up the 'Amount (LC)' line items that correspond with each Period entered. For instance, I'd like to see a total sum of the individual…
-
Different Time Scale problem
hi! I want to display the values from a module with a Time Scale of Half Year to a module with a Time Scale of Month. Can i do it? Please help me.
-
Circular References
Hi All, This is a pretty usual issue that I have seen others encounter as well but wanted to check if you have an elegant way of making it work. I am trying to calculate the available inventory at hand on a particular day using the closing stock on the previous day. So Day 1 would pick closing stock of Day 0 and calculate…
-
L2 Certification
How many Exams are there in L2 certification. Is it 3 or 4 and how many attempts are allowed per exam as well as per Questions?
-
Deafult Forecast Errors
i m trying for Default Forecast and also with Round formula..I m confused about the formula. Can somebody help for this ?? I got the Baseline Forecast and Growth Rate%
-
COLLECT() function issue
Hi Community, Please see attachment for the details of the issue. Any feedback is appreciated Regards,
-
Level 2 Sprint 3.3.5.5 Final Shipping Method and 3.4.3 Country Made in
No matter how hard I try I am not able to the right formula for Final Shipping Method, so far my formula is "IF NOT Override Shipping Method OR ISBLANK(Override Method) THEN Shipping Method... Another query is do I have to give a formula for Country Made In line item...if so can anyone give me a hint?! Thank you in Advance…
-
3.3.5.3
I have configured the hierarchies properly but the parent Hierarchy is not visible in my INV01 Inventory Ordering module
-
2.3.9 Activity: Historic Volumes to Baseline Forecast
Hello, When comparing my DEM03 Demand Forecast numbers to the Anaplan example, my Default Forecast seems off. The DAT03 Historic Volumes appear to match. Anaplan example: what I see on my DEM03 module: The Default Forecast matches the Baseline Forecast for FY20 and the Growth Rate % doesn't apply until Week1 FY21.…
-
DEM03 Demand Forecast
Hi, My DEM03 Demand Forecast is not matching with the Check your work data. When i select All accounts for a product SKU, my data is different from the training material. I am not sure how i arrive at 2024 in Default Forecast & 2004 in Final Forecast. Please help me sort this out. I have attached the screenshots for…
-
L1M1 13.9.3 Activity: Add Primary Grid to Volume Entry Page
Hi, In this section Allow editing tab is greyed out for me. Am I missing something here or I need additional permissions to have this. Also this section is not visible to me. Please can someone help me with this. Thanks, Balarama Krishna