-
How to check Currency based on Company Code?
Hello, Which formula should I use in order to bring the correct Currency based on the Company Code? I try with FINDITEM and LOOKUP functions, but I guess I'm doing something wrong, as I have errors. Thank you in advance for your help!
-
REP04 Employee Expense Summary Formulas
I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and results below and would like guidance in developing the appropriate calculation formula. First Attempt (1A): Created a basic…
-
no values for FY20
Hello all, i am doing level 2 Sprint 2 activity 2.3.9, where i need to use FY 2019 data in order to populate FY20 (ofset formula). My model calendar is at FY 20 while time range is for 2019. but for some reason when i scroll to the right there is no 2020. i might have missed something in previous steps, and now i am…
-
INV01 Ordering Inventory Export
My export file seems to have everything okay except for the 3rd number onwards on the first row. And I used this formula IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory
-
NOW Function
Use case: As a user, I want to display the current time (e.g. 9/12/2018 5:00AM) in a cell. This should behave similar to the "NOW" function in Excel. Business case: When a user presses a button, we want to display the last time the button was pressed.
-
How to Identify Number within text and show number as final result.
Hi All, Can Someone help as to how can we Identify number within a Text Formatted Line item and move those numbers to a new line item with number as a format using some formula. E.g. Line item 1: Text Format : VV123BO Line Item 2: Number Format : 123 ( the line item 2 should automatically identify number in Line item 1 and…
-
3.4.4 Activity: Create Stock Exceptions Review
My numbers are coming out larger than the given numbers. Lloyd
-
Dropdown list vs Radio buttons
We have radio buttons for Site selection on the new UX and I am asked to change that to dropdown list. In order to make the line item a dropdown list, I created the line item with the List format (Site). It seems I can't make Site a dimension of this line item. A lot of the filters in the system were set up based on the…
-
Get Consolidated Data from a User dimensioned module to a module without User dimension
Hi, I have an input module with a user dimension, published in a DB where End users can enter the inputs. I want a consolidated module where I can view all the entries/data but without user details or dimension as it has nothing to do with users. I used the User dimension in the input module to avoid overlapping or…
-
3.3.5.3 Check Your Work
I need help I am getting negative numbers for my beginning inventory and the week 1 comes off as a 0. On top of that the "Override Suggested Order Amount?" Boolean is not allowing me enter anything even though I have allowed the write access.
-
Help on circular reference
Hello, During my training, I had to build the Inventory ordering module for the supply chain model (level 2). After building it following the instruction, I'd like to test new formulas to determine the Suggested Order Amount for the Month. I'd liked it to be equal to the Forecast demand + Safety stock target - beginning…
-
A list item value should be equal to the sum of values of other list items.
Hi friends, I am having a issue related to list items. As shown below, I have a list with items a, b, c, d. I have used this list as a dimension in a module which has value(number formatted) line item. I also have other list with items a, b, c, d, e, f, g. Now, this list is used as a dimension in other module which also…
-
Unable to pull data from DEM02 module into DEM03 module
Dear Experienced Anaplanners, I am at Level 2 Sprint 2 trying to use formulae to add data to Demand modules. As per the lesson, I've created DEM01, DEM02 and DEM03 modules. DEM01 and DEM02 are Volume Growth Rate by Month and Volume Growth Rate by Week modules respectively. I have used formulae to pull data from DEM01 to…
-
Many to Many Dimensions Rollup
Given: End user can input in the following 9 columns as a dropdown(List Format) in the Input Free Form. Free Form is a module having a Numbered List applied which is having these Line Items as a List Format so that users can choose from the dropdown. Following is the count of List Members in the lowest level.…
-
Formula to add line item from Monthly set up to QTY
Hi Community, I would like to ask if this is possible. There are 3 modules done but 1 module is set to monthly and the other is set to quarterly. See below for the illustration: I had to create an illustration since I cannot provide screenshot from the model due to confidentiality. This is the revenue module. And then they…
-
TAR01 Detailed Sales Target Level 3 Model Building
Hi, I have a question on the LI "Initial Country Sales Targets" in Module TAR01 Detailed Sales Target. For this line item I'm assuming that we are pulling from the TAR01 Sales Targets where the initial country sales targets are calculated. Would I then use my SYS03 Module to SUM by Country and Product? Below is a screen…
-
Retrieve Current User
Hello, I can use item(user list) to get current user, i.e. the user who login current system, it requires to use user list as dimension. Now I have a module which is not dimensioned user list, is it possible to retrieve current user directly without adding user list as dimension? Thanks in advance.
-
Properties and Subsets Enabled For User List
Quite literally what the title says. I am able to point and click on the different features just like a regular list, or I can apply the User List for specific roles to reduce sparsity. There are advanced methods of data entry, where validation is done up front, preventing bad data from entering the data set, that could…
-
L3 Percentage calculation Not Matching
L3 Sprint 1 - User Story 5 My Percentage is not matching This is my Ratio. Let me know where I'm going wrong.
-
Formula that will pull from another LI every other Thursday
Hi, Need help on how to set up a formula for a LI that will pull from another LI every other Thursday? Thank you
-
Year values to months
Anaplanners, For an input screen, I want to enable users to input at a yearly level and then I want that same value to flow to every month pertaining to that year automatically. This is to make life easier for the end user to not input data at a monthly level, rather do one input at the year. Example. Value for FY 20:-…
-
A Way To Create A Custom Time Aggregate Filter and Selector
Custom Time Aggregate Filter and Selector by @JohnB & @ShaneenW We present our approach to creating a custom time aggregate filter and selector. We look forward to learning a more efficient approach to creating a time aggregate filter/selector or tips/tricks to shorten the approach below. 1. Create a flat…
-
Calculation of modules & Size....
Hi Everyone, Can anyone help me to understand, how we are calculating the module size in GB format? If I want to see the actual size of my modules in GB then, do i need to enable any option in Anaplan. Regards,,, ___________________________________________________________________________________________
-
In the drill down window being able to filter on values for non blank or non than zero
Hi Anaplan, It would be amazing if within the drill down view you were able to filter on a list of values for items that are non blank or non zero. So for example if you're looking at a calculation with a dimension that has 1000 items you can see only the relevant items with non zero or non blank values that contributing…
-
How to get the Index of a Numbered List Item ?
Hi guys as the subject, I want to get the Index of a Numbered List Item, what attribute/property should I use? the Propeties I've tried: (Item )Index (Item )ID (Item )Number (Item )suffix by the way, what is the data type of the index? Thank you~
-
CUMULATE circular reference
Hello, There are similar posts on this topic, but none of the solutions seem to work. I am trying to create an inventory calculation that allows the user to delay/push production to subsequent periods. Then, the total production that has been pushed will be produced at one time. CUMULATE is currently used to aggregate the…
-
Summing of list items to another list item in the same list
Hi There is a requirement that we need to sum list items total to a specific list item in the same list based on some selections User selects Yes/no one line item(drop down) and Revenue method on another line item(drop down) Lis items which are having Yes should be summed to the % revenue method list item attached…
-
2.3.10 activity
I need help, I’ve been on this section for a couple of days and can’t seem to figure out why my data is not populating. My formulas are correct but I’m not understanding.
-
Formula to get code of a parent
Hi, What formula can be used to get the code of a parent list inside a flat module? for example in this particular module the parent is a numbered list and I want to bring its code in the 'Code' line item( Text Format). What method can I adopt to achieve the same? Thanks
-
Need Help: Circular Reference Error
Hi Anaplan Community, I have been thinking of ways to pull Prior Year value into Current Year. Previously, I used OFFSET() formular where I would offset -52 weeks. I have created a demo module below to showcase the original formula, the formula that give me circular reference error and the backup formula. Recently, to…