-
Sum of grand total of transactions
Hi, I am trying to sum a column within a module on open balances for all of my bill-to Customers. The reason for me doing this is I have them by aged deductions and then I used the SUM function onthe aging buckets to get the total of that particular customer. Now I would like a calculation that tells me what the percentage…
-
Compare Values Incorrect color for negative version amounts
For a line item that has a saved value that is negative (take net income for instance), a less negative or positive value to compare to should be green, but is highlighted as red when you use color coding with the compare tool in Anaplan. Has this issue been identified before? Seems like it would be an easy fix since in…
-
Wizard to help Anaplan business end-users to write-down formulas and create objects on models
Wizard to help Anaplan business end-users to write-down formulas and create objects on models. This wizard such as an Avatar could be the AnaFriend indicating the best function or best way to use a specific function or Anaplan models objects such as list, subset or module.
-
Numbers of Months (elapsed time) since a month when consecutive zeros are started
Hi Anaplaners, I would like to figure out numbers of months elapsed since consecutive zeros have started. (please see the attached). For instance, in the attached file, as sales of product BBB is zero since July 2019(instead of April 2019), I would like to get "4"(months) given current period is Oct 2019. Thanks in…
-
Color Theme Formulas
Giving different sections of a formula different colors to organize while writing it. Especially when writing a longer nested-IF formula, it would make the organization of the formula easier as well as decrease opportunities to stall the model.
-
Fetching Count and Sum Information different Reports
Hi All I have an audit module which has a list as dimension. The list contains multiple report names. The List is pivoted as rows and line items has 2 columns as Count and Total_amount. My need is to go to respective source module of the reports and fetch the total count of records in that report and sum(Total_amount) in…
-
Retrieve a max value from given dynamic periods
Hi, Anaplaners I posted a similar question before (https://community.anaplan.com/t5/Best-Practices/Time-where-a-value-is-max/m-p/40577#M4185), but this time I have faced an issue that cannot be solved by the solution I get to received in the previous question. Thing is that (see the attached) the line item "MAX Value" see…
-
Time Dimension - date
Hello, Am trying to make a calendar in Anaplan to plot weekdays and holidays. Time dimension for the model is "DAY" and I wanted not to type the dates in each days, but to put a formula instead. What would be the formula to return the "date" of the time dimension to the line item. I tried to use "ITEM(TIME)" but it does…
-
Calculations
Hi experts, we mainatained joining date, Resigned date and last working day properties in employee dimension. Based on those properties we need to calculate previous 6 months Organization Active employees and resigned employees count. We create one module called headcount planning module.In these scenario current period is…
-
Property based filter
Hi Experts, In Employee list we maintained one property called Reporting Person. In Reporting person property we maintain reporting employee names for eg: manager reporting to owner , Supervisor reporting to manager,Staff reporting to Supervisor. In Selection When i select Owner position then Show all owner combination…
-
Property based filtering
Hi experts, I have a requirement But i am cofusing acheive the requirement. In employee list we are maintaining some Properties like (Joining date,Resign date,Last working day ,Position,Employee Type, Department,Salary properties). In Employee Module, i want to get data based on page selector selection. Suppose, in page…
-
Need Formula Help
Hi all - I am very new to Anaplan and have just finished the Intro to Model Building. As a test for me before going into Intermediate Model Building, I tried to set up a copy of a report I currently have in Excel. The report is to show revenue by PI for each month & the % of their revenue at the site they are located. I…
-
Formula does not work in QA but in Dev
Hi Experts, I am facing a unique issue, I have modified an formula on a line item with number format and it does pulls the resulted value in Dev enviornment but when the solution is migrated to QA, the formula does nothing and the line details read message as " Drill down unavailable for this cell: No other data cells are…
-
Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are given as
Used IRR formula in a Model but it is returning NaN as result whereas when Same numbers are given as a input to IRR formula in Excel it is returning a numbe
-
Ability to format a cells by logic instead of numbers such as blank or not blank
Hi Anaplan, It would be really useful and if you could format cells by logic instead of numbers directly on the cell. This could work by having blank or not blank in the formating parameters or true or false. Thanks, Usman
-
Comparing partial SUM values of lines of a list.
Hi, Anaplaners From the first table in the attached file, I would like to compare (calculate changes in values in %) first year vs second year and second year vs thrid year. The former compares sum of 2012 - 2015 (2016 should not include as 2016 for the second year is always zero) and the latter compares 2012 - 2014. Is…
-
COUNTIF - How to add sequence numbers within groups of repeating values
In Excel, I can apply sequential numbers within each group of values. For example - Column A has groups of values which Column B applies sequence numbers to the members of each group. The number sequence in Column B is generated by COUNTIF($A$2:A2,A2) which is copied in every cell in the column. I see that Anaplan's answer…
-
Linked Formulas
Forgive me if this has been posted, but I did my due diligence and nothing turned up. It would be awesome if formulas had a click-able hyperlink to its source cells, similar to when you double click on a cell in excel to show a formula and it highlights the precedents. Its also similar to "Drill Down", but instead of being…
-
Version serlection
Hi Experts, Filter Module Row axis -Line Item Members- 1)Actual filter 2)Forecaste Filter 3)Budget Filter 4)Plan filter Column Axis -Time -Future 4 years 1) Actual filter applies only for actuals Version only but inthe above screenshot it applies all versions. IF Startperiod>Period(currentperiodstart()) AND…
-
MAX, AVG, NON BLANK over list dimensions and YoY Averages (seasonality) for TIME dimensions (2 Q's)
I have a Line Item "Conversion %" in a module that applies to a fake time dimension list called "Aging Days" that ranges from 0 - 365. Module: 0 / 1 / 2 / 3 / 4 // ... // 365 Conversion% 1% / 1.5% / <blank> / <blank> / 1.6% / 1.6% / .... // 26.5% If you see the above data, it is a curve (cumulative %) over 365 days.…
-
Lookup in Anaplan but with different dimensions
Hi Everyone, I have 2 modules: The first being 'Module - Calculate' with 2 dimensions: 'Site and Services' and Time. It has 2 line items, number of days and total cost. The second 'Module - Rate Table' with 2 dimensions: 'Site' and 'Numbers'. It has 2 line items, number of days and Rate. Reason for separating the Rate…
-
Version Selection
Hi Experts, In page selector When i select Version selection.The following periods need to show remaining periods are hide Version is actual then i show previous 6 months actual periods non-editable Version is forecaste then current period to end of the with in the year data. Version is Budget then next year all periods…
-
Ability to double click and open a summary line item
Hi, It would be nice if we have the ability double clicking to open a summary line item.
-
Identifying if a list item is a property on a separate list
Hi, I have two numbered lists, City and Product. Product has City as a property. All Products have a City as a property, and multiple Products can have the same City as a property, but not all Cities may be linked with a Product. In a module with City list as a dimension, how could I identify if a City has been linked with…
-
Create a composite hierarchy from a file where parent-child relations are expressed as two columns
Hi, Anaplaners I have a question regarding how to create a composite hierarchy from a file where two columns alone indicate a hierarchy (parent-child relationship). Please see the attached for the detail. Is such a transformation possible ? Thank you. GregModeling
-
Test if a specific month is selected then do something
Hello, I have a module,and within it I use Time as a Page selector in it. My time is formatted like this : Calendar Type : Calendar Months/Quarters/Years, Fiscal Year Start Month: Jan, Current FY : 1 Jan 2018 - 31 Dec 2018. For a specific line item in my module I want to test something like this : IF Jun is selected THEN…
-
HOW TO READ CURRENT PERIOD BY USING FORMULA
Hi, In one module i want to read current period.Can you please suggest me what formula i use Foe suppose we are in jan-19.I want to read current Period(Jan-2019) in Filter module. Regards, Uma
-
requires cell info loaded in particular year
Hi All, I am trying to write an formula which should plot "year" info, where it was loaded in a list. This is about dates we manually loaded in a particular year. Now i want to extract the year info on the cell where this was loaded and not the year that the date mentions. For example we loaded 31-Dec-2018 in Year "2019"…
-
Hide Blank Rows
Hi, I have a module in which few rows have blank value with changing parameter. Can i put some formula or any way in which only the rows which are non blank will be displayed irrespective of there changing parameter?
-
Summing from week to quarter between timeranges
Hi everyone, I have encouterend a problem that keeps bugging me, so I would like to share this with you guys! In a model I have two timeranges: Model timerange: 2 years, months, no quarter totals. additional timerage "Long term": 5 years, quarter totals. Module A: Model timerange: Lineitem 1: timesettings: weeks Lineitem…