-
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…
-
Select Function using Versions
Hi, In version settings, I have 2 versions 1. Actual 2. Forecast but none of those versions are marked as True for Current (Refer screen-shot). I Created 2 Modules 1. Source Module 2. Target Module Source Module has Versions and Locations as a dimensions, Line Item - Source LI (Number) Target Module has Locations as a…
-
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…
-
Data Store
Hi Experts, May I please know how calculated data is stored in Anaplan? For Example, we have 3 line items A, B, C. A and B have values 10 and 20 in a module. We write a formula for C = A+ B in the module. So in the backend, does Anaplan store the values of A and B only without storing the calculated value of C in the disk,…
-
Is there a way to set a numerical goal and track its progress throughout the quarter on a Dashboard?
I am looking for a way to communicate a sales goal by product and channel on a monthly basis. Please let me know if you have any ideas, Thanks!
-
Data load for duplicate rows
Hi All, I was trying to load data into a module, but my data file has duplicate rows. when I load the file, I was expecting the duplicate rows to be ignored or flagged as duplicate record value but it getting added in the member value. Example: Dimension Line item(amount) row1 ABC 10 row2 DEF 20 row3 ABC 30 row4 DEF 40…
-
CUMULATE WITH LISTS WITHOUT CUMULATING WITH TIME
Hi, I am having a module having a list dimension and weekly time scale. I want to cumulate the values of a line item w.r.t list items without cumulating it w.r.t time. Is there any way to do so ?
-
Count back for turnover
Hello everybody, I've come across a task to count some KPI's based on count back method. For instance, I need to count how many days it takes a company to cover its Account Receivable (AR) amount with monthly Revenues. It means that if a company has AR at Jan end = $ 2000 and Revenues as: current month (Jan) = $ 200…
-
Make the round function work as intended
Description of the enhancement required: The ROUND Function is not working as expected. An example of the enhancement: Make the ROUND Function work as intended. A story for why they want the enhancement, (how would it help their business process): It has been documented on Community…