-
Weekvalue formula
Hello, I'm trying to pull weekly data into a module that is based on months. I've tried to use the WEEKVALUE formula, it returns 0. My source data has a week value assigned to it. Thanks Hina
-
Exclude Zeros From Average
I am calculating an average but I do not want the zero values to be included in the average. How can I exclude them?
-
Using Lists in IF formula
I'm trying to create a formula to say IF 'countries-filter'.'1' LOOKUP[Countries.'UK & ROI' ] THEN 'Actual (Current View)' - 'Forecast (Current View)' ELSE 'Actual (Current View)' - 'Forecast (Previous View)'. My countries are a list, so i created a Boolean module. 1 - UK 2 - IT 3 -DE I don't think i've set this…
-
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…
-
Create Child in Numbered List
I had the original Model, and I was trying to replicate it. The pic 01 and 02 are the Original ones. The pic 03, 04, 05, 06 are my Model. It is restricting me to enter the values:- Soft Drinks, Tea.... I even tried creating .txt file and import it but it failed too. I need your kind help for this. Please feel free to ask…
-
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…
-
Why won't my vendor roll up to my Total department. It seems to be only this vendor.
I created a a vendor call MISC. Its to group all the vendor under a certain amount to MISC rather than showing a bunch of vendor. When I select Total Department, MISC won't show up. But if I go to the specific department call N/A or No Department, which is the roll up level. It will show up. I tried moving N/A around to…
-
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
-
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! ****
-
System Default date
We are building dashboard with workflow, where user approve/reject demand plan, would like to keep system date so that we will know when user made changes. It would be great system default date and time can appear there. Thanks,
-
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…
-
Distinguish between List Item or Line Item
Dear Members, I am new to Anaplan, so I would request your generous help. Order Number or Transaction Number is a Line Item or List Item? And if the answer is List. Then let me know, if millions of transactions happen daily in any Retail chain or Bank. And if we create Numbered List for the Transaction, after 1 Billion…
-
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?
-
SUMPRODUCT function
Analogue of SUMPRODUCT function in Excel
-
FIND list items by property value
Currently you're only able to use systm properties: Name and Code to identify List elements. Please add an optional argument in a FIND functions that would allow to use any single exact property in the selected list as a reference.
-
Code property
ITEM is not an occupied system property while CODE is. This makes the formulas ITEM and CODE not equivalent and thus inconsistent for Anaplan modelers. Since CODE() and ITEM() are very similar formulas, it would be nice to make their syntax similar. The practice that we use to keep formulas simple is creating “item”…
-
LOOKUP towards a line item that has less dimensions
Please add an option to use LOOKUP function towards a line item that has less dimensions. For example: I have a line item that has three dimensions: * Client * SKU * Month I try to get some masterdata from Region, Month level that doesn't have SKU dimension. When I try to use [LOOKUP: Client.Region] towards this line item…
-
Have BOHY showing the YTG numbers for every Half Year period
Description of the enhancement requiredCould you please add to the enhancement list the task to add a new standard subtotal for timescale?We are very interested to have BOHY showing the YTG numbers for every Half Year Period.A story for why they want the enhancement, (how would it help their business process)We have been…
-
Display Name User Selection
Hi, At present within Anaplan it is possible to dynamically change the contents of a Display Name (on a numbered list) and to give the end user the ability to change the Display Name (or its alias) as required. However the problem at the moment is that this solution is not scalable. i.e. if User A were to change the…
-
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?
-
Currency Page Selector/Filter
Hi, I need to be able to create a DB that allows me to choose what currency to display. At the moment I have data in various currencies, a currency conversion module has been made which hosts GBP, Local Currency and USD. I've created the FX List. What I need to do now is on the dashboard somehow create a page selector that…
-
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…
-
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…
-
Updation of master data and its reflection in spoke model
I performed an incremental load / full load of the master data(lists) from my Data Hub to a Spoke Model. Now, in my data hub, I renamed a list item in one of my lists and I want to update the same in my spoke model in some way without having to manually change the same in the spoke model. Is there any way to handle this…
-
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