-
Level 1 Model Building Exam - Activity 5
Hi all, I'm stuck with the calculation of the bonus, car allowance,... by Role for more than 3 hours now. I get an error message referring to the G2 Country hierarchy, but G2 Country is not even in my formula. Is there some link I should break? Thanks in advance for your advice, Valerie
-
Activity 1.5.2 (My question: How do I rename a new level 1 model?)
I am not asking how to rename the Example model, that was done. I created a new level 1 model and named it but I want to follow the correct format shown in the Activity 1.5.2 which should be L1MB-my name.
-
Exam Activity 6
I know I can't get answers, but I feel like everything should be correct in my formulas. However after I entered all of them, they just populated 0's. I've checked the source material it's pulling from and it's all seeming accurate. Could someone help point me in a direction to troubleshoot the lack of data? Thanks!
-
Activity 3.1.4 Set time dimensions
Hey guys Do we save the settings after completing the steps on setting the time dimensions?
-
I want to add time as dimension in existing module
I have created module without time as dimension. Now how to add time as dimension in the existing module? Can anyone help me please?
-
Publish with Time and non Time Line items
Anaplanners, Quick question. I have two separate modules 1) Module 1..dimesnioned by only Project List with X number of Attributes as line items. 2) Module 2 Dimensioned by Project List and Time and line items. Is there anyways that I can have a single a view, with Project names as row headers and Time along with non time…
-
Recreating Excel Formula in Anaplpan
Hi, Trying to replicate this same Excel Formula in Anaplan, but leads into a Circular Reference. Please advise on how would do so. The Excel Formula and the Formula we are attempting to us in Anaplan are below. Excel Formula: =IF(AND(AJ31=0,AK31=0),AJ103*AK$71,IF(ISBLANK(AK31),AJ31*AK$71,AK31)) Anaplan Formula: Thank you
-
Dynamic List Name based on selection/input
Anaplanners, So I have a numbered list, which is used to populate project names by the end user. Projects are created in Anaplan by the end users, they provide name of the project and input various other attributes pertaining to the project. However, I had a doubt on one new request, if the user selects a particular region…
-
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…