-
Creating an As-Of Version
Hi, I was wondering if users can create an as-of version in Anaplan. Thanks in Advance, Daniel
-
How to model annual inflation in Anaplan?
Hi Anaplan Modeling Experts, I found it is not that straightforward to play with timeseries data in Anaplan, when the calculation logic for a specific item is referring to the values of itself from the previous period. In this example, I am trying to model the annual inflation rates. In Excel, it is quite easy, just type…
-
Option to pick a separator, when using TEXTLIST as "Result = Source[TEXTLIST: Mapping]"
Good to give user the ability to pick or type a separator instead of default comma, as there might be commas in the orginal text strings already.
-
Boolean Formula - Match line item with date to date on column i.e. item(time)
Hi, I am trying to write a boolean formula that will create the check mark where the formula finds a match between another line item containing a date and the calendar date on my columns, i.e. item(time). Attached are my current views and what I am trying to accomplish. Can someone please help me write this formula? I do…
-
Delta load for Numbered lists
How to implement Delta load for Numbered lists in Anaplan ?
-
Fake to Real Timescale
I am trying to map a fake time list (months) to the real months timescale so that I can create a time filter off of the real timescale for the fake timescale. What would be the best way to do that? The fake months list has the same format at the real one does (MMM YY).
-
How to flag a period using boolean?
I have 12 months worth of data, but only want to flag Aug-Dec. I can't do it by checking all the boxes as there are over the 10k limit, so I'm trying to develop a formula where it essentially says, if period > July, true else false... Any ideas on how to easily accomplish that?
-
Level II Sprint III Model
Please suggest a Link from where I can download the FP&A Model.
-
History information seeking
Hi Friends, Any lights on how is ID values generated? It is sequential but why it starts with 200? I hope it's not year.
-
Looping in Anaplan
How to apply this formula in anaplan ? CF Inc/dec in Receivables = (@PRIOR(Customer Accounts Receivable)+@PRIOR(Other Receivables)-@PRIOR(Accounts Payable - Intercompany))- ((Customer Accounts Receivable)+(Other Receivables)-(Accounts Payable - Intercompany))-CF Inc/dec in Receivables
-
File Missing in Level 2 Sprint 3
Hi, Is there a .csv file for the Shipping Methods and Time taken for delivery? If not then it is not mentioned how should I populate it? Regards,
-
Safety stock import filling missing
I find the safety stock import .csv file is not uploaded in the Sprint. The image I uploaded is an old one shared in the community. Can someone please share the file or assist how can I download it?
-
Issue with value addition
Hi Community, Can someone help me understand, why am I not able to fill in any values for Volume Line Items even manually.
-
IF and Then for ISACTUALVERSION and Forecast periods
Hello, I am working on Strategic Planning where I have actuals for 2019 and I am projecting for 2020, 2021, and 2022. I have a formula where I want to apply a 3% escalation starting in 2021. My current formula uses ISACTUALVERSION and Offset. Here is the formula: IF ISACTUALVERSION() THEN 'Actuals'.Period[SUM: 'Actuals'.AU…
-
Real to Fake Timescale
I am trying to map the Anaplan monthly timescale to a fake timescale that I have created. I have a location that has a date MM/DD/YY in which I am wanting to map that to my Month list that consists of Month 1 through Month 60. I am trying to do a formula that will map that date as the Month 1 list item and then each month…
-
Lookup data from two line items with different format and "applies to" lists.
Hi, My current build has been full of surprises. Right now I need to lookup start dates for new employees, but, the module I am building and the model from where I need to take the data, both use different lists. As you can imagine the lookup does not work and I cannot just pull data directly over without a formula. Do any…
-
Need to use lookup or similar, dependent on two different flat lists
Hi, I am quite new to the Anaplan Community. I have searched quite a bit, but, have not found an answer to the question I have, so I'll ask it and see if someone might be able to help me. I am currently building a module where an employee should be able to see his/hers ramp % for both current and previous roles. The ramp %…
-
VARIANCE command
When we define an item we can set the number Format to Numeric and tag if an "Increase in Value" is Good/Bad/Neutral. Why do we not have a VARIANCE function to utilise that increase in value indicator? So if we have three different Versions ("Actual", "Budget" and "Actual vs Budget" and 1 item called "Sales" (with an…
-
Copy last entered cell value to all
Hi, I am facing a problem, can someone solve it, please. I have a module which has Employee, Time Range(FY01 to FY15) as Dimensions Line Item - IP(List format), Growth % (Number Format) IP Line item is user input, by selecting a list item from a dropdown. Growth % - Value(Name(IP)) - Will change to number format. Let's…
-
Linking formula
Hi, Please see details on the attachment. Regards,
-
Day Count Convention (YEARFRAC)
Hi, has anyone found an alternative to Excel's YEARFRAC-Formula? The formula has various day count conventions such as Actual/Actual, US 30/360, Actual/360, etc. I am trying to get the year fraction for different time periods but it's quite complicated in Anaplan. Best, Evgenij
-
Re-ordering list item subsets in the list setting section
Hi Anaplan community, I believe I have just encountered an Anaplan bug but wanted to share if anyone has experience the same issue and whether it is a known bug. When creating a list item subset I have attempted to change the order of the list item subsets but even after changing the order and returning apply the list item…
-
Count with time dimension
Hi, I would like to ask something with regards to count with time dimension. The details are in the attachment. My apologies, i had to recreate the file since I was informed that I cannot post actual screenshot of data from client. Please see attachment for details. Regards,
-
Swtichover set to False driving Formula error
Hi team, I have a Line Item where the Formula Scope = All Versions & Use Switchover = True. When I turn the Switchover off I receive a 'Formula is invalid' error I have tried removing the formula, setting Switchover to False & return the formula by the same error ocurrs I cannot see why this error would be happening. My…
-
Territory Allocation Urgent
-
Rounding function giving different result for similar numbers
I am using rounding function to convert 3 decimal places to 2, but the function is giving different results for similar numbers. Original NumberRound to 3Round to 2 P131.49496$31.495$31.50 P235.49528$35.495$35.49 This should be 35.50 Formula used for rounding to 3 - Round(n,3) Formula used for rounding to 2 -…
-
Selective List Export
Can you please tell me is it possible to export particular two List Members and corresponding Line Items?
-
About the imported display method
Import to dashboard using anaplan connect. I want to display only items that have been imported and entered Is there a way to automatically display only items that have been imported and entered? Can you filter automatically? I'm worried about setting the line item formula or setting the filter. I would be happy if you…
-
PROPER() Functionality
When we are dealing with Text formats in Anaplan it is case sensitive and it throws unexpected results if we don't do it exactly the way it should be. Although we can achieve this by amalgamation of LOWER, UPPER, FIND, LEFT & RIGHT functions. Having PROPER function would greatly reduce the need to do so.
-
Ignore Value Parameter for MIN Function
When using a minimum function, it would be ideal if we could exclude specific values, or a list of values, to avoid returning zeros or another value. For the aggregation function x[MIN:y] you may want to exclude zeros from the formula. Currently the workaround is to use a large number in place of zeros, eg: "IF x = 0 then…