-
Time Dimensioned Data to No Time Dimension (Last Non Blank)
Hi Community, I am trying to take data that is dimensioned by two lists and time to a module that is only dimensioned by one of those lists and no time. Module 1: Dimensions: List 1, List 2, Time Line Item: Formatted as a month and calculates Start Date and has it show up for the month that it is in (ex: Feb 20 is start…
-
New formula for checking User's access
As a Model Builder, I would find new function really useful: Syntax HASACCESS(x,y,[f]) Returns Boolean, "TRUE" if User has specified access, where: * x: Users list-formatted line item containing . * y: Item of the list with Selective Access enabled. * f: Flag which tells which access formula should test, keywords: "ANY"…
-
How to enter the time in a line item?
hi! I want to make a module to know the elapsed time. But I don't know how to enter the time in the line item. Please let me know if there is a good way. I want to make it look like this.
-
Non-Production Data List Items References
It would be great if for Non-Production Data List Items, a model builder could see what references the list item. The only way to do this right now is to try to delete the list item and let the model roll-back so you can see where it is referenced.
-
calculate values from modules with different dimensions but with same ancestor list
Hi, This is my first post so I hope the example will be clear. I have a ‘Customer Hierarchy’ list and a ‘Product hierarchy’ list. Both lists have the same parent hierarchies (see print screen 1 below) Now I have a Sales module with the customer hierarchy as dimension and 2 line items (sales volume, product) The product…
-
Create range based on input line item
Hi , Please help/advise on how I can create a condition where we can automatically calculate our rebate based on the uploaded volume. I created a separate list where i define the range and the corresponding rebate. In my calculation module, i need to lookup the rebate based on the volume that was uploaded. My problem is…
-
2.3.8.4 - % by week
Hi - how far off am I this being correct? 'DEM01 Volume Growth Rates'.Growth % * 12 / 52
-
List item to line item (without using select function)
Hello There is a module having Account list(30 list items) with balance line item. Another module having 10 line items (which need to fetch data from 10 list items from Accounts list) used select function to refer data(which is not a best practice) [ex:balance from 1st module[select:list item]] Is there any option other…
-
How to use SUM with the Users list? Why invalid?
I have a situation where I am trying to create a summary values for the Users list and have them be arranged by a 'type' mapping. I have a mapping module dimensioned by users and my 'product' list, with a list formatted line item to determine if it is applicable to them and what type it is for them, and I was hoping to use…
-
Filter line Item
So I have a module wherein there is 13 line items. 1 is a Text Line Item (text formatted) and the other 12 are Jan Feb.. Dec (12 months number formatted). I'm not using the native Anaplan time. I however want to filter the display of months based on the version selected (not native version). Say if it's Version 1+11 which…
-
User List with LOOKUP function
Hi, I am trying to use standard users list with LOOKUP function, but i am getting an error "Invalid use of "Users" list with function 'LOOKUP'. I can see many posts in community says Anaplan looking into this enhancement. Is it real?, If yes. does any one have an Idea when it will be released. I appreciate your reply.…
-
Retrieve Users with Write Access from User List
We have built a dummy User List in system, selective access enabled, so user can set write access to those users. Is there anyway to directly retrieve the list of users who have write access? Attached pic to illustrate the purpose: User2 was given write access to User1 User3 and User2 itself, we'd like to get a list of…
-
Intermittent Anaplan Interface Error Message
Hello, Former Anaplan Support member here. I was just about to create a Support Ticket for this intermittent error message, I wanted to see if there were others who have run into this message before? 1) I am checking to see if other users are facing this issue. 2) This is not model or workspace specific. I have already…
-
TAR01 Detailed Sales Targets
Hi, I want to make sure I'm understanding the intended logic of the TAR01 Detailed Sales Targets module. From the user story it says, "I will know this is complete when I can see the percentage of the country’s actual sales revenue by product family that each account’s actual product sales contributed to per quarter." So…
-
lookup and error message
Hi Please advise on what this error means : lookup error - please see image attached - thank you IF Employed? THEN 'EMP03 Employee Drivers By Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 data type mismatch : format other than LIST or DATE being referenced as…
-
Sum values from all Versions
Hi, I am trying to sum the total value from one line item for all versions. The source module contains versions and the module containing the calculation does not have versions. The formula I used references the source module and line item and returns the value from the current version only. Is there a formula that can be…
-
Level 3 - Sprint 1 (4.6.5) - Lookup isn't working correctly
Hi, I'm a little stuck on Level 3 print 1 section 4.6.5. The formula I'm using looks correct but the lookup to accounts section isn't returning the correct values for me. 'Data_01_ FY19_Sales_Revenue'.Actuals[LOOKUP: 'SYS03 Account>Product Details'.'A1 Account', LOOKUP: 'SYS00 Time Settings'.PY Qtr] This is the formula I'm…
-
List properties in a Module
Hi All, I am working on a model where I have a list with 3 properties(B,C , D). List AProperty BProperty CProperty Duxyz In a module with Dimension as List A the below mentioned format is to be generated where in a column corresponding to the above mentioned list items all 3 properties can be brought: Module with Dimension…
-
Reference next item in a list
is there anyway to reference the next or previous item in a list by using a formula? I saw a post a while ago that inferred that this was not possible without quite a bit of conversion logic. thanks, josh
-
Sum data from a module with line items to another module with a matching list
Hi Could someone suggest a solution? screenshots attached also. I have a module (PER01) where I have these line items - the data is by employee (from employee list): - base salary - incentive scheme - other social costs I have another module (PER02), where I want the above data to fit in with only 1 line item called…
-
INV01 inventory ordering Foreast Demad line item.
Hi, In INV01 Inventory Ordering module I am getting the below value for forecast demand , where as in Training Material it is showing 2048. I have checked a couple of times of this value but not able to track the issue. Please let me know where I am going wrong here. Forecast demand value I am getting fromt this module…
-
Applying Boolean formula from a time dimensioned to a non-time dimensioned model
Hiya, I have 2 modules: Meldaliste Sales - 2 flat lists, time System_Product_Filter - 2 flat lists The flat lists in both modules are the same. I need to create a boolean formula in System_Product_Filter that says if there is a blank cell in Meldaliste Sales then false else true. This formula isn't working because I have a…
-
Function similar to PREVIOUS for Line Item
Hi, Can we have an another function similar to PREVIOUS so that it can bring the value of previous line item. Example: There are two Lists and three line items (Op Bal, Exp and Cl Bal) in columns. Page Selector (List 1) : D1, D2 and D3 Row (List 2) : F1, F2, F3, F4 and F5 So when I go to D2, the Op Bal should equal to D1's…
-
DAT02 PY Revenue to CY module
Hi, I am having trouble with the formula in the DAT02 PY Revenue to CY module. Steps I have performed thus far: 1. Pulled from the Historical Data in the Data Hub into the DAT01 module in the Sales Planning model (dimensioned by A1 Accounts, P2 Products and F19 Time Range) 2. Created DAT02 module in the Sales Planning…
-
Select first week of the time scale by user
Hi, Current I have designed like this to select first week of the time scale. But I am wondering is there a way in ANAPLAN That If I select one check box for that Line ITEM, it will disable all other check boxes for that same Line ITEM and If I uncheck it , it will enable all other check boxes? Here I have maintained a…
-
2.3 DAT03 Historic Volumes
Hi, I have historic figures for volume in DAT03 for FY19 that have been offset to give me baseline forecast for FY20. How do I achieve the same for baseline forecast in FY21 as currently my baseline demand ends at Dec 2020. I also cannot seem to enter the ROUND formula correctly in DEM03 to get the Initial Demand Forecast?…
-
FIND formula not working
Hello, We have an line item composed of all the Sales Reps associated with an account (some only have 1, some have multiple). This line item is text formatted. This line items is called "Sales Reps" We then have a second text-formatted line item, which is a text field, called "name," and the functionality we are looking…
-
DEMO 03 Baseline Forecast showing zero's for FY21
DEMO03 Baseline Forecast module showing zero's for FY21 I have used four more formula's along with the shown in this image. Formula 1 : IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' then OFFSET('DAT03 Historic Volumes'.Volumes, -52, 0) else IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' then OFFSET(Default…
-
Formula questions
Hi, I'm attempting to write a formula to pull in the percentage amounts of a line item in a different model in accordance to a certain vintage year. I'm trying to use either the LOOKUP or SELECT function but getting a error. Please advise. 'R01 Inputs'.Funding Scaler[LOOKUP:Vintage] Thank you
-
How to get only one value from a module that contains Time
I want to get only one value from another module without having a list. The ideal is to display the value of the first month of a module with Time in another module that has no list. I am not good at English and it may be difficult to understand. Thank you.