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 current…
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…
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 i…
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 f…
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 hav…
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 …
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, set…
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$…
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…
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 L…
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…
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 mod…
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…
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 ?
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…
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 enhanceme…
There are two other ideas that exist already one that are by default set sums to off and another that is to set defaults by module. Why limit to just as a whole product or module, why not give a defau…
Hello, I'm hoping I can get some help with using an IF formula to combine a criteria. The following three line item formulas are working correctly: Then I have the following two line items that show w…
Hi We are getting some inconsistent results with round function in Anaplan which is causing bit of an issue at a client's end . I have seen few posts relating to round function so may be a know bug . …
Hi , I have a line item Amount in Module A, and Line item Final Amount in Module B. both modules uses different List but the member in module B is a line item value in module A(text field). I want to …
Is there a function that will return whether a list item is a member of a subset? I can't figure out how to get FINDITEM to return a value. Example: I have a list of accounts segmented into three subs…
Planners, As most of us are already aware that ROUND was not working as expected in Anaplan and we tried multiple workarounds to get this work done - Anaplan has now enhanced this in the latest releas…
Hi AnaPlanners, I am trying to run a stimulation based on a business scenerio wherein i take in the baseline % and apply a CAGR (in %,can be negative or positive) to the baseline % to get my year on y…
I am trying to make a one stop shop for KPIs that are found across multiple modules and are dimensionalized by a days list. I need to find these KPIs in terms of the L1D, L1W, L3W and L6W and have it …
Hi All, I have a requirement and this is a very rare formula. Please help me with the same. In Numbered list has Duplicate Products for different parents. For Ex: Product A is a parent member it has a…
