-
ALM - How to LOOKUP native Versions
Currently, using SELECT statements in formulas for native versions - Actual/Forecast. But, this will not work with ALM, so what should be an alternate approach for looking up native versions in formulas with ALM implementation?
-
Filter on line items that contain a specific text
Hello, I have a module with many line items, and I want to filter on all line items that contain a specific word (e.g., "home"). How can I do that? Thanks a lot!
-
Anaplan Level 2 sprint 3 INV03 formula showing up as blank
Hello, For the line item "Stock Exception", here's the formula I wrote: 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center] However, if I select "All Products", it is showing up as blank. Is there an error in my formula? How should I…
-
When Adding A New Line Item - No Data Format
I would like to request that when a new line item is added into a module, rather than defaulting the format to Number as is standard, it defaults to "No Data". Immediate ROI: - Automatically won't toast the model if you write a formula without changing the format * In another post, someone asked what do you "always forget…
-
Relabel the time dimension
As a model builder I want to have the ability to relabel the time dimension using a specific property/alias so that I don't need to create extra complexity and I can use all the benefits/functions of the time dimension to meet the users's requirements. I will know this is successful if I could rename FY18 to YearXX and…
-
Subsidiary view Data
hi Team, I have text lineItem (Role change from ASN) and second linitem (Role ID for ASN Role) applies to subset, I have a boolen value (Bu role?) that need to be true if text value is present in subset. adding my three fields below. formula written not working as expected. Any help appreciated. Thanks Jerin
-
Planning whole units by a curve
Hi. We have a requirement, in which the customer wants to plan a given number of units to be sold by a monthly curve, in which you only have to plan whole units, i.e I have 45 units and the % of the curve in Jan 23 is 3.45%, so the units to be planned in Jan 23 should be 2 instead of 1.55 (the result of multiplying 45 *…
-
Anaplan Optimizer across time v2
Dear Community, I want to use the Anaplan Optimizer to optimize planning/capacity utilization across our supply chain. Got inspired by this link which shows that the Optimizer can in fact take time into account: https://community.anaplan.com/t5/On-Demand-Courses/Optimizer-Dynamic-Time-Setup/ta-p/74604 My challenge is that…
-
Need help for the logical formula of having a running balance
So basically I need help in the formula for arriving in the 'Final' line item. I tried using Previous formula but I am missing something in the logic. Thank you!
-
In 2.3.10 of Spring2use an intermediate module to align the source with the target
In Sprint 2, Create Demand Forecast, "Remember that Anaplan can automatically aggregate data upwards (from lower to higher levels) in the hierarchy, but in this case you will It is necessary to use an intermediate module to align the source with the target", for the second half, how to achieve it?
-
Check item present in list and return TRUE or FALSE
Hi Team, I am planning to compare list item from LIST A with lineitem Assignment code (text format) in same module. if item present in list A boolean line item in same module will return true else FALSE List A contain assignment code as follow: How can I achieve this? Please help. Thanks JJ
-
How can I make this LI go over time
Hi, I'm having trouble making this LI be spread over time. What is the best way to go about this? Thank you
-
Dynamically show list items in drop down based on a condition
Hi Team, Please refer the image below. The above image shows two grids on the page. Both have same list dimension. I need to build a logic that dynamically changes the items in drop down in the right grid's line item(list formatted called 'Stage') based in the status shown in the left grid item(list formatted called…
-
Financial Planning
Is there any model by which i can learn financial forecasting Thanks In advance
-
ALM with Select Function
I know that the ALM has draw Back of Selcect Function.BUt, I want to understand why the Select Function Is DRaw Back and why Can we use the Select Fucntions in Production lists
-
Anaplan Optimizer across time
Hello everyone, Want to use the Anaplan Optimizer across time, and have found out that I can not use a line item running on the native time scale in Anaplan. Hence I am on the quest to create a list of the months and have been following this…
-
Calculate headcount by time
I'm having issues counting the current headcount by month. I have employee hire date, leave date, and projected leave date. I've attached snap shots of my modules. I haven't figured out how to include "projected leave date" into my formula yet. I'm stuck on trying to get the current employees based on historical leave date…
-
Calculating the Average Per Cash Curve
Hi, I'm trying to Calculate what my average would be in a certain month using a rate curve. My rate curves are inputs that are located in a inputs module and I believe I would need to multiply them by my average to see what the average would be over time. The only issue I'm having is that my input modules with the rate…
-
Need Calc Help
Hi Community, I am working on this use case. Wondering if this is possible. DAT01 Emp Details Emp | Start Rate EmpA 15 EmpB 16 EmpC 17 SYS02 Zone Module Zone| Lower Range | Upper Range ZoneA 14 15 Zone B 15 16 Zone C 17 100 How can I identify which Zone does an employee falls in. Final result needed Emp | Zone EmpA Zone A…
-
Setting Planning year based on date
Hi, I have system module for time settings, and based on Today's date line item I'm trying to set Planning year which is current year + 1, when I'm selecting date between jan to dec 2022 it is showing me plan year as FY23 which is correct, but when I'm selecting date from JAN 2023 to Dec 2023 "Planning year" line item is…
-
Formula Evaluation option in Anaplan
Would be great if Anaplan has a Formula Evaluating Functionality similar to Excel. We build a lot of multi step complex logic in Anaplan and only the final result is shown. Excel spreadsheets allow users to step in to a formula and evaluate it step by step viewing the result at each level. This becomes particularly useful…
-
Combining Data in two different Modules
Hi, I have LI's from one Data Module that I need in another Data Module that doesn't share the same dimensions. The common mapping I would use would be BB Contract ID. What would be the best way to go about this? Target Module Source Module Thank you
-
Sum values without activating the Sum in blueprint
Hi, Is there a way i can get the total value in a list without activating the SUM in the line item blueprint? I want to save the space so i want to use None in Summary but i need to get the total in another module where i don't have the list. Thanks, Tom
-
Level 3: Sales Planning model to the Japanese Sales Representative details
Hello Can anyone help me on this one, The example on the check build 6.4 are not **** on my end my result:
-
Help getting the Average of a LI in accordance to List
Hi, I'm trying to get the Average of the LI "Principle Balance" by two list Items names "Turn" and "Vintage". I'm not sure if I would use the AVERAGE function in Anaplan or a TIMESUM function. This LI is in a module that is not dimensioned by time. Below is the Blue Print and pic of the module. List Items List Item Blue…
-
Auto generation of Code
Hi everyone, We have list of Activities that are being uploaded in a numbered list with Activity Description and Expense Group as Unique Properties. Requirement is to generate Code in Anaplan based on Activity. I've tried different approaches but not able to fulfill all criteria Example: - Activity DescExpense GroupAnaplan…
-
problem in using lookup statement
in sprint 3, i have been tasked to create a country summary output module with G2 Country and P1 product family as dimensions and stock safety flag count as line item. The line item will take data from inventory module which has stock safety exception count as line item and put the data in country summary module. Now the…
-
Lookup funtion return blank values
Hi, I have the 2 modules below and did a lookup function but it returns blank values. Am i missing something?
-
Need help avoiding Circular Reference Error while using POST formula
I am working with a system that calculates what payments should be, then when the actual payment is made we record what that value and save it back into the model. Sometimes there are retroactive changes, which cause a variance between the calculated and the actual amount. We want to be able to post the variance to a…
-
OEG Best Practice: Inside the Hyperblock
What are blocks? How blocks are calculated – General Lists How blocks are calculated – Native Time/Native Versions Hyperblock performance Summary block counts Should I worry about blocks? A reason why we shouldn’t focus on just the block count Focus Points We recommend this article to Experienced Model Builders and…