-
Cut line item list formant
Hi! I've got line item formatted as a list. This list has got a different level of summaries. Is there a way to cut somehow this dropdown list so the summaries wouldn't be included, ie there would be only items at the lowest level of the list? Thank you.
-
Summing Module Results at Different Levels in Hierarchy? Even when I exclude the parent.
This is in regards to the SUM on the bottom right corner when you highlight the total number. It varies from different Hierarchy level of my chart of account. I have a parent and child chart of account with a top level. Ex. COA. COA L1 Top level is Total GL When I click total GL only and not select the rest, it shows me…
-
Sorting of list when used as line item
Hi, I need to change how list hierarchies are sorted when used as format for a line item. See image below; In this case, I have 2 lists, where the ones named "Parent" are L1-level and "Child" L2-level. As shown in the images, the child are above the parent. I want it to be the other way around. Does anyone know how to do…
-
Line Items Not at the Hierarchy of the Line Item Subset
I have inserted line items into a module where I have a line item subset set up. In the module where I am using the line item subset, the inserted line items do not fall in the hierarchy in the subset . thanks iosman
-
employee cost center change
Hi, I have set up employee list where in cost center is the parent. But how will the change of cost center be handled in Anaplan? If I just change the parent of the employee then the change is retroactive which should not be. Any suggestions? Thanks, Ana
-
COUNTA formula in Anaplan
Hi, I was wondering if there is in Anaplan the equivalent of the "COUNTIF" Excel formula: basically counting the cells in that range that match a specific condition. I was thinking of using it for calculating the % of Cost Centres that have input data so far against the one that have no values. Many thanks in advance! ****
-
Simple yearly average
Hi All having completed the 102 course I am in the process of building my first model, so please be gentle if I have asked a ridiculious question but I really cant figure this out. I have a line item showing balances across time periods and I would like a second line that shows the average for the financial year for the…
-
Sum one Line Item based on the value of another Line Item
Hi, I'm wondering is someone could help us with the following: We have a transaction module called "Data Store" which is made up of line items (columns) and a Transaction Unique Key (List - Rows) Refer "Image 1" for the Pivot View... Refer "Image 2" for the Model view. (This is a subset of the data contained in the module,…
-
How to get the average of the last 3 month from the same line item for Forecast version?
Hi, I am doing an OpEx forecast. How do I write a forumula to get the average of the past 3 month from the same line item for the Forecast Version only? I also want to be able to override the amount manually or by upload if needed. Is this possible or do I have to create another module to link it?
-
Need unique element through versions
Hi! I've got a module with few dimensions, including versions, I generate code there for a list to update. So I need to filter unique code. Currently, I use formulae: IF RANK(1, ASCENDING, SEQUENTIAL, TRUE, 'List name') = 1 THEN 'List name' ELSE BLANK But it does not work properly through versions (return duplicates) Is…
-
Dependent drop down list
Hi, I have a mapping module in one of my models, where I want to map a sub-scenario to a scenario. I have one dimension in my module, a list called "Scenarios". I have one line item, "Sub-scenarios" where the format is a list-subset to a list called "Sub-Scenarios". The sub-scenario list if below the scenario list in…
-
Source Module
What is a Source Module Tab?
-
Data Split
I have data of products sales in years (FY17, FY18, FY19 & FY20), how can i allocate it to monthly for a given financial year?
-
create a formula to show actual and forecast in same line
Hi, I need to be able to show actual data and forecast in same line item. I have an actuals line item, forecast line item, then total view line item. Formula i have written is IF Time filter.Actual Months THEN Actual ELSE Total Forecast It returns the forecast but I should be able to see actual months data, it returns 0.
-
How do I sum a selection of weeks using a look up
Currently we have a formula that is returning the last week of the month from the look up. How do I get the look up to do a sum of all weeks within the month ? CURRENTVERSION()'.h_collect previous version[SELECT: ..., LOOKUP: Time filter.'H2 End wk']) The H2 End week needs to be a sum of the month ...
-
using finditem when there are two of the same names in a list each with a different code
Hi, I have a line item in this module called "TPS System Takeout" and in the column next to it "TPS Competitor Report Type Classification" i want it to find the matching name in this list "CTO Competitor Classification Types" You can see that RaySearch was populated because the code for RaySearch in the list is…
-
Task option in anaplan
What is task option in anaplan ?. Can anyone give brief explanation on that.
-
How to split vendors into Above a certain amount, show vendor name, else show and MISC.
Doing an OpEx forecast. I have the usual OpEx Account list and Department list along with vendor list. However, on the module, I want to show vendors under the GL. When I do this, it shows all the vendors and I want show vendors above a certain amount. Any idea on how to approach this? I tried a numbered list but I can't…
-
Linking subsets to a new list
If i have created 5 subsets from a long list and a new list (Subset 1 to 5). Is there a way i can set the formula in my properties of my longlist to command that all items included in the subset 1 shall be tagged as part of the new list for Subset 1 instead of doing it manually? Thanks in advance! Appreciate your help! 🙂
-
Sum by lookup
Hi, I want to sum the total Categories in each Quarter-Year in this module using this column in this other module please help! Thanks 🙂 Amanda
-
Is there a formula to get the current date?
Hi, Is there a formula to get the current date? Thanks, Ana
-
Salary Calculations
Hi, Can someone help me to understand the salary calculation, how it will calculated on the basis of merit increase% Thanks Shweta
-
NPV Formula with time adjust.
Hi, I need to replicate this formula from excel: =VNA(wacc;cash flow)*(1+wacc)^0,5 Could you please help me? Thanks Nacho
-
Drill to transaction
how to do drill to transaction in other source system
-
Simple check on Data
Hi, I think this should be an easy solution, and maybe i am trying too hard Consider the module below, data coming from a list start date, end date, and a count (1 = yes, 0 = no) I want to populate Previous YN with a 1 IF the promo count was 1 for the previous period. So in the example above #2: 31/01/2018 to 28/02/2018…
-
Mean time interval between transactions
Hi All, How to calculate mean interval between transactions per material in the following module which is one dimensional. Thanks Arun
-
Formula Help - Check on only entry
Hi everyone I need some help with a formula. I want to create a line item (LINE ITEM B) to check that another line item (LINE ITEM A) only has an entry in one period. The line item that I want to do the check on is a manual input and has a numeric format. I basically want the model to flag an error to tell me if there are…
-
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
-
Formula
Hi Experts, I am using two line items, Both line items are text format. Line item 1: FCST_1 Line item 2: FCST_2 For suppose FCST_1= 5.4591 Then By using FCST_1 we need to calculate FCST_2= 5,46(Rounded value AND instaed of dot we need replace comma) To do the requirement i write the below formula FCST 2= IF FCST_1 = 0 THEN…
-
Running balance of a numbered list
Is it possible to get the running balance of a numbered list? my numbered list is a daily cash transactio and i need a line item taht will get the running balance per transaction. Thanks!