-
using Parent and Item
I have a module that is products (div, dept, class) x locations (channel, store) x time (week). I have a line item PRD_PARENT. I want to know the parent product at all times. lowest level product list is ProductsL3. I set the format for PRD_PARENT to be list ProductsL3. I set the formula to be PRD_PARENT =…
-
HOW TO SELECT HALF YEARS
I know how to use the select function to select a time period e.g. SELECT [TIME. 'FY13']. However, I need to split my data by half years. Is there any way of selecting a half year or a group of months, e.g. Jan to Jun.?
-
Create running total not associated with timescale
We are looking for a way to assign decile values to transactions where the order of a measure in a module determines its ranking. We cannot use the RANK() function (without a subset workaround) as the number of transactions exceeds 1M. The CUMULATE function only applies on a timescale. Has anyone found a way to do this?…
-
When building a formula, unable to select a Line Item from another module..
When building a formula, unable to select a Line Item from another module..
-
Can a version formula be defined just for a single line item?
This question was asked of me recently, about use of version formulas. The current behaviour is that a version formula applies to a set of line items, rather than a single line item.You identify the set by reference to a named line-item subset. The rationale for this is that if you’re setting up a formula for a single line…
-
SELECTING Current Version
Is it possible to SELECT current version For example, instead of coding [SELECT: VERSIONS.Forecast3] where Forecast3 is my current forecast and Forecast3 gets hardcoded in the formula. Can I code something like [SELECT: VERSIONS.CURRENT] or something similar?
-
Publishing Actions for General Use
Hi Is it possible to publish an action so that general users (who do not have admin rights) can run it, e.g. for exporting data? Thanks
-
How to avoid references to specific years in a formula
I've just been asked about a problem with rolling forward a model from 2011 to 2012. The model had references to full year values, which had been made using a formula like this: Full Year Value = Source[SELECT: Time.FY11] While this works, it requires the formula to be updated every year when the timescale for the model is…
-
Quarter to Date Ability
Anaplan has a great Year to Date summary in the Time settings, is there an easy way to show quarter to date (QTD)?
-
Interest Payment and Principle Payment Functions
Is there any easy way to replicate the IPMT() for Interest Payments and PPMT() for Principle Payment functions in M. Excel within Anaplan? I can only find a PMT() function in Anaplan.
-
Input Process Function
ALL: I have an idea for managing data input based on a matrix of 4 dimension intersections in a module, based on a trigger boolean stored in a like module. My question is simple; Is it possible using any function (known or unknown) to use a formula in the module, to check the boolean intersection of a second module to…
-
How to move from a Model with Timescale to a model without time scale?
Need help in aggregating the values which are available in a model with timescale (and other dimensions) into another module which has all the other dimensions except the timescale dimension. This is required to show the summation or the closing value of the timescale module value at an aggregate level into the new module.…
-
Best Practise for Loading Actual Data
Would anyone have a process defined for "How" to load Actual data into a model. I get that I need an Actual data file with tuple detail. And then I load the data into a Module, likely that has base members to load values. BUT my issue is then, how do I get that data into other Modules, when I cannot run a test against the…
-
Move a start_date and a end_date from a flat module to a module with Timesc
Step 1 - A flat module allows to enter data of recruitment of permanent or temporary staffs. Step 2 - I wish to charge months from the start_date until the end_date of exit, when it exists, or the end of timescale if end_date doesn't exist. If I succeed in putting my indicators correctly, I don't manage to recover dates.…
-
Is there a Quarter to Date summation function for a weekly timescale?
Please help me finding a way to sum up the weekly numbers to the Quarter to date values. That is , the value should reset to zero at bigginning of every quarter and sum the cumulative value week on week of the quarter. Any help here would be greatly appreciated. Thanks Saurabh
-
Line Items Not in 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.
-
How do I have a forumla calculate data to a specific dimension member?
How can I have a formula calculate data for a specific member of a dimension and place a 0 for the others?
-
Collecting the value of a parent list in calculations
Hi, I want to collect the value on the parent membrer for the employees list of my source line item to calculate my target one I did an example like this one target_lineitem=source_lineitem[SELECT: Employees.PARENT(ITEM(Employees))] but it doesn't work can someone help me.
-
Rank function on LineItem Subset
I have a module containing: - timescale - versions - 1 list (offices) - lineitem subset based on PNL module - 2 lineitems (1 = collect(), 2 = rank(1)) I need to rank every PNL values independently and need help with formula or approach to do it Now by default - Rank function set rank for all values - e.g it compare values…
-
Line item reference
I have a currency module containing Line Items, Time and Version with the line items as currency codes and the values as exchange rates. This has Line items as rows, Time as columns and Version as a page. I have a details module that contains amounts in local currency and a currency indicator. In another module I want to…
-
How do I sum across dimensions other than time?
Can't see how this was done in the allocations video. I have a list for products, and a line item for sales. I want to introduce a line item that returns the total sales for all products against every product. Beyond allocation use, is there a way to introduce a line item that returns the value at the next level up a…
-
How to use a drop-down list within the PROFILE function
Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a drop-down list from a number of different allocation profiles to use in the PROFILE function. To hold the different…
-
Create Subtotal of Existing Line Items
How do I make an existing line item a subtotal of other line items? Line items below: - Opening Stock - Purchases - Issue of Stock - Closing Stock Formula should be: Opening Stock + Purchases + Issue of Stock = Closing Stock