-
Fp&A case study access (299)
Fp&A case study access 299Could you enable my access to FP&A Case Study please. I have completed courses 100, 101, and completed certification for 102, 201 Saurabh Sharma saurabhsharma08@hotmail.com saurabh.sharma@acgindia.co.in
-
Delta Load
How to do incremental load when there is change in any one of the list properties?
-
How do I get the data from a line item of a list in a module into another module?
I have two module. One call assumption, another. call Implied new room. I want to get the data from the line item call mix which is base on my subscription list from the assumption module . In my Implied new room module, I have 3 line item with the same name as my subscription list. I don't want to use a list because I…
-
Text function; Automatical conversion to scientific notation
Hy everyone! I'm encountering a problem with converting my values to text with the TEXT() function. My problem: When the value is 10,000,000 and I use the text() function, there is no problem. The text line item will show "10.000.000". When the value is 10,000,000.15 (with 2 decimals <> 0), The text line item wil show…
-
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