Hello Modeler's I would like suggest one enhancement or feature, this is the thing I feel like anaplan should have search option. As we know most of us not like to scroll a lot for what we need. I fou…
Hi Guys, I am unable to load data in Volumes. The issue is that file is loading sum of all the columns into single month. e.g. in Jan'19, data for Jan'19 from file should load, but it is first summing…
I have been trying to figure out how to solve this issue that keeps popping up when I enter this formula: IF Employed? THEN 'EMP03 Employee Drivers By Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Det…
Hi, Trying to look up a Line Item Subset to use in a formula. Example of the formula is as follows. IF ITEM(LISS C67 Commissions)='LISS C67 Commissions'.'52053 - Internal DS rep commission'THEN 'R18 L…
Hi, I am trying to achieve the following output in Final Value line item. 1) Till the first override the system should take the Value line 2) Once Override is checked, the system should take the overr…
Hi, I am new to Anaplan. I would like to have a formula that pulls data from module A if the month is earlier than say Feb 2021 and to extract value from module B if the month is from Mar 2021 onwards…
We are doing a project around Margin by SKU and I am having trouble mapping/allocating product cost to a dynamic Time dimension. Attached is what our flat cost data looks like. DL is the location, 141…
Dear Anaplan Experts, I have below module using Days as time dimension. I also have a line called fake days where I mapped the system days to a fake days list. Then I would like to do a LOOKUP to pull…
hi! I want to concatenate the strings! When displaying the time, I want to use "hour" + ":" + "minute"! Example: "9" + ":" + "15" → 9:15 I'm not good at English, so this may be difficult for you to un…
HI, Can someone help the below requirement. Need to get Prior year data, I know to use offset or lag, But for FY, I need to get the data what i have in the prior year (FY) only, when using offset or L…
Good Day!! I have a scenario where I'm trying to calculate the moving average from actuals in Custom Day time scale. In a module, I have sales data to be uploaded, from the sales data I have to calcul…
We need a function which can give us timestamp on last data entry for a specific cell. This will help us to compare that time stamp with our custom date in some specific use cases. example: Todays Dat…
How can we apply break back to the line item that is having filter, for example I have one list with list items 1,2,3,4. In a module I will use this list as a dimension and will apply filter which wil…
Hi, I have created dependent drop down list line item. . See below example data entered by user. Rack Market City is based on Rack market State. Market -StateRack Market - CityAlabamaBirmingham, ALAla…
Hi Anaplan Experts, I'm not using native time and wanna use the SPREAD function. However, This function needs a time scale. Some functions can't run in custom time, such as OFFSET, LEAD, PREVIOUS, ETC…
My formula is not working. Here is what I have: IF 'Sales Trend V4'.'2019A' = Gross Sales.'2019A' THEN 'Sales Trend V4'.'2019A'[SELECT: GL Name Sales.Sales] / 'Sales Trend V4'.'2019A'[SELECT: GL Name …
Hi I'm trying to lookup data in the format below. My LOOKUP formula is working but the issue is its only picking up the first record (Product P1). P2 and P3 are ignored as the numbers are the same. Wh…
Hello! I have found very gentle and beautiful solutions for filtering lists if they are composite ones, but i am struggling to build a filter for a-non composite list which has 5 levels of detalizatio…
Can some tell me why I get 0 for the medical expenses? It doesn't give me an error message but just shows zero. I posted screenshots I used this formula: IF Employed? THEN 'EMP03 Employee Drivers By R…
From 1 line to several, so that a same dashboard can have several use cases (compact table to work on, then small/medium/large images to have a recap to browse).
hi! When I check list items in the parent hierarchy, I want to create a mechanism to check all items in the child hierarchy. What i should do? Please help me.
Hi, I am trying to enter the formula for a question in L2 S3 exam. It says my answer is incorrect but in the model it is giving me the desired result. I want to confirm that my understanding about AD0…
for the override amount write? line item is my formulae correct 'INV01 Inventory Ordering'.Override Suggested Order Amount? AND 'Submit Purchase Order - Write?'
I was trying to capture roles of the current user in a line item, I see that we cannot refer the model role from user settings directly The other way i can think is to take export in a csv and upload …
Documentation is one word that gives most model builders a cold shiver. It’s associated with binders full of information lost in archives or the output of rushed efforts to complete an implementation.…
Hi Team, I have a situation where some cells have had data entered to them & this is proved by the cell history but the cell is BLANK. I am struggling to understand why the cell history is not reconci…
Hello, I have a situation, I have a list named "BOM Lvl 1", with the parent "plant sku", and these parent have a "total price". Then, I have another list "SKU Plant Price" where the "Plant SKU" is the…
I would like to ask if you may give timesum function ability to accept other function within timesum parentheses [ex: Timesum(previous(revenue),start period, end period)]. The main reason I asked this…
