-
Drill Down View Enhancements
Drill downs in Anaplan Modules should have a feature for checking what each part of the formula written does. For example if there is a If condition with a nested loop with multiple formulas and conditions in it, then there should be a provision to select what each condition does regardless of the condition being True or…
-
MAILTO functionality trouble shoot
Hey Team, I am facing this issue on MAILTO. I tried getting it in two ways: - Option 1: - Used MAILTO functionality MAILTO(u, v, w, x, y, z) Result from triggering this option from the backend and frontend (NEW UX) has led to an error where the line breaker (%0A%0A) inserted in the body of the mail does not function.…
-
Phone Cost for Sales Department
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 Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0 I know it is something with the Roles list and the…
-
Line Item Subset Lookup
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 Lending Summary'.$ Funded/'R18 Lending Summary'.'Total Cash Collections*' ELSE 0 Formula is not going through because using a…
-
Calculation Logic across Time dimension
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 override value and copy it across the remaining timeline unless a new override is done Can someone please help in defining the…
-
Check the first day of every month.
hi! I want to create a line item in a module with a time axis of Day, where the first day of each month is checked. What should I do? Please help me.
-
Formula to Select data based on Month
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. What is the formula to do this please? Thank you.
-
How to map/allocate product cost over time based on flat data?
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, 14190 is the item/SKU, and the 11/12/W1 are different cost types (variable, variable + labor, etc). We've got the cost and then…
-
Map Result from System Time (Days) to Customer Days (Fake Days)
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 the data from the above module to a module with the fake day list as dimension. Time is not a dimension. THanks for your…
-
String binding
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 understand. Thank you!
-
remainder of division
hi! I would like to know how to calculate the remainder of a division. Example: 5/2 → 1 , 45/7 → 3 Thank you！
-
Moving Average in Custom Timescale
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 calculate the moving avg of 90 days at the day level. Dimension in the module Article, Custom Day scale. Line Item -Sales Qty,…
-
Spreading amounts
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. What are your thoughts on calculating asset depreciation with the LOOKUP function?. Kind Regards,
-
Formula error
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 Sales.Cases] ELSE IF 'Sales Trend V4'.'2020A' = Gross Sales.'2020A' THEN 'Sales Trend V4'.'2020A'[SELECT: GL Name…
-
Medical Expenses Level 1
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 Role'.Medical Benefits[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0
-
Renaming the line item - Best Practices
Hello all, I need to rename a line item in a large model, I am wondering what are the best practices to do this? What should I consider before renaming to avoid destroying the model? Thank you in advance for your help!
-
hierarchy list and child list
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.
-
L2MB-S3 AD02 Override Amount formula
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 AD02 is correct. Override Amount - Write? is a Boolean formatted line item. Formula for this line item is based on INV01…
-
AD02 Inventory Ordering Overrides
for the override amount write? line item is my formulae correct 'INV01 Inventory Ordering'.Override Suggested Order Amount? AND 'Submit Purchase Order - Write?'
-
Capturing User roles
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 it back to required module but is there any other way which will not need export? My ultimate goal is I wanted to mask data…
-
Blank Cell with History
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 reconciling to the data in the cell. Please see the attached screenshots for an example but effectively I was expecting the value…
-
Allowing Time Sum function to accept 1st argument a function
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, I would like to calculate the average 3 month based on previous figure. [Excel example] In meantime, I would also like to…
-
line item: First week of timescale?
how do I build the formula in 'Sys01 time settings by week' for this line item
-
Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Hi All, After working on the formulae in this section , the expected result is not as shown is section 3.3.5.3. Please find attached the screenshots of the "my output", "expected output" and the "Sys01 time setting". Request you to guide me where am I committing the mistake so that I can proceed. Thank you, Har**bleep**ha.
-
L2S3 Sys00 Time settings by month module Planning Period Filter
To add line item: Planning Period Filter? Saved View Name: Planning Period Filter for UX * Show only the Planning Period Filter line item * Filter to show months only I added this as a line item planning period filter as Boolean and entered true and then deleted it also added a filtered function filter by the line item…
-
Query sales order data into sku properties
I am currently working with a dataset that has all sales order information and have the goal of creating a boolean formula to mark true if a sale on a product has occurred in the last two years. The data module and sku modules are related based on a column with item ID numbers, but I am having trouble pulling the sales…
-
Custom Time Aggregation
Dear Anaplan Experts, Would it be possible to build a custom time aggregation function while still being able to leverage our system time functions? For example, I am doing some salary calculations at the granularity level of day, then I would like to aggregate the period of 2022-05-25 2022-06-24 to June 2022 because our…
-
L1 MB Certification Test: EMP02 Employee Expenses
Hi- I'm trying to update the formulas to reference the drivers in EMP03 Employee Drivers by role. I keep getting an error when i try to update the formula. Do you know why this error is happening?
-
Parent Child addition
Hi , I need a help in calculation of data at lowest hierarchy level giving values to parent level. For example, l0l1L2DataExpectedFunction usedAa1b11133=SUMIF Aa1b12233 Aa2b2111443 Aa2b2222443 Aa2b2110443 Here, I want values added of all the l2 who has same parent. Can anyone suggest me way out? Thanks, Divya
-
SUM results not matching up to summary
I'm having an issue with SUM giving me unexpected results. When I'm working with hierarchy lists and just need a top level sum rather than subtotals at all levels of the hierarchy, sometimes I'll use a 1-item list, add a line item set to this list item, and SUM over it to get the top level sum. It's a little convoluted but…