-
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…
-
How to know current User ID
Hi, I am trying to create a DCA where in the requestor should be the only one to be able to Submit a request. In this example for this module, I am logged in as user id Camille@abc.com. since the requestor is Mark@abc.com, the Submit checkbox should be disabled since me(Camille) is not the requestor. Is there a way to do…
-
IF Then Else Issue
I want the Repair and replacement = Flat terminal then 1 else o (or) True else false No getting the result
-
IF then Else issue
I am Having two list formated line item, NOw i want chek true or 1 base on the one list item to other list item how can i acheive that
-
Parent hierarchy & Top level
Hello fellow Anaplanners, I have a query, I was going through an existing model and where I saw there are multiple composite hierarchy built having just 2 lists. i.e one is parent list (say 'X') and another is child list (say 'Y'). Now here in first list 'X' (which is parent for the other) there is only 1 member 'All X…
-
Hey, How can i Autogenerate Codes in a Non-Numbered list?
-
Statistical forecasting App in UX
Hi all, I can see that there's a statistical forecasting App on the App Hub that can be downloaded but it looks like everything is in Classic dashboards. Does anyone know if there's a version of the app that uses the UX? Thanks
-
Lookup Sales Based on drop down list
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get the sales from the similar store. Module 1 Dimension : SKU, Store List, Time (Line Items: For Expansion?, Similar Store…
-
View access based on User list
Hi, I have a module where users create New Cost lines. Since the security is based on Groups, users can see costs created by other users within the group. Now the ask is that users should see the costs created only by them, for example, User A would see cost items created only by A, B should see only B's lines etc. Note…
-
Pulling value from another line item in the same module
Hi I have an Emp List. An employee can have 2 records in the list (the 2nd one with an extension ABC OR). I need to pull the values of the 2nd record in another line item of the 1st record. Could you please suggest how to show the values in Red below? Thanks Is ABC OR?Projected salesABC OR SalesJohn DoeY1000520John Doe ABC…
-
Summary Settings in module Blueprint view
I'd like to know the difference of Summary settings combination in the blueprint view between: Summary- Formula, Time Summary: Same as main summary vs Summary-None, Time Summary: Formula If possible can anyone explain me with a small sample data like this:
-
Pricebook to flow down from Parent to Child
Hi, The above are currently in the system where L4 is a list of distributors. I do not want to touch/amend since i am new to Anaplan and do not want to mess up anything. I created a new list as below; I have created a system module to link L3 distributor to L4 Customer in the earlier list. After which, I have also created…
-
Applying different formulas to list
Hi, i'd like to ask about how to apply different formulas on each item in a list. As You can see, Module 1 shows actual data from the current month. Module 2 is a forecast module, where the baseline column is from the previous month actual data, while the Growth % and Growth column is an input column for expected growth…
-
How to create a module where i can link existing module to a new list
Hi! Not sure if the subject header make sense but here it goes. I have a existing module that have pricing by distributor by month by SKU, example and lists used as below; Different distributor will have different prices by SKU The above are currently in the system which i do not want to touch/amend since i am new to…
-
Date function not working
Hi, I'm trying to convert Open date line item- text formatted in to Date using Date function but getting blank in Date Final line item, could you please help me where I'm doing wrong
-
Open Source model in Formula bar
Drilling down gets exhausting. When you are in the module tracing a formula, when you click the chevrons to bring the formula window to the bottom of the screen, functionality to be able to right click a formula and a window opens to give an option to "open source model" just like in drill down would be awesome.