-
Circular References
Hi, I am having problems with what I think should be a fairly simple calculation but I'm not sure what I'm doing wrong. I have a debt value. Interest is calculated on that debt value. Every 6 months, the cumulative interest is added to the debt value and the interest for the next 6 months is calculated on the new debt…
-
Import in a numbered list
I am facing this error while importing the values in the numbered list. Can someone please highlight what this error means.
-
Circular Reference in module with no time dimension
Hi All, I have module which has no time dimension and with 3 line item Bond, Sale, Total Calculations are as below Bond = total (When i right this formula its throws circular reference error) Total = Bond + Sale I have getting circular reference error, Please let me know if any solution to resolve it. Thanks & Regards,…
-
What does the little drop down menu icon in Actions do ?
Screen shot Currently it says no actions available atleast for me . Wondering if anyone has any 'Action items' showing up there ?
-
Import Action Error
Hi Anaplanners, Need help with the following error: Can you please let me know how to resolve this..? (See the pictures) Thanks in advance, Ankur Sonthalia.
-
Error message: Cannot breakback
Hi all, I have a dashboard for forecasting and I want to allow users to copy from one quarter to another quarter, using breakback (at a quarter level instead of monthly level). For some reason, whenever I try to copy values from one quarter and try to paste them into another quarter, I am getting this message: Cannot…
-
Pouplating year value without Time dimension
Hi All, Can you please help me in populating the attached years by formula , where I am not using Timescale in the module and my Mapping Year (line item) format is Year. CHRT** and YR** are my two dimensions used here.
-
Improve FINDITEM() when used with Time
Similar to improving imports with time periods (Idea Link), it would be great if the FINDITEM() formula was tweaked when working with Time, to make the formula return time periods for strings like Jan-20. Reason for asking (lifted from my previous post in the Idea Link): The standard excel format for Month-Year is MMM-YY.…
-
Add conditional formatting icon sets
The 'Icon Sets' feature in excel conditional formatting is a tool that I really like. It looks very clean, and can convey a broad amount of information quickly. It would be great if Anaplan could incorporate some of these into the conditional formatting menu, using a similar logic to excel. For those unfamiliar with icon…
-
Add shape to New UX cards
It would be great if page builders could change the shape of certain cards within the new UX. For instance, the ability to choose between rounded square, circle, or rectangles for KPI cards This would give page builders more options in: * aligning page themes to corporate branding * displaying visual data in creative ways
-
New Style for Line Items
We have had a client request for a line item style with one line above and two lines below a specific line item. This style is very common in financial statements and SEC filings and would be beneficial if it could be reflected in Anaplan. I have also seen requests for the style to be reflected in the dropdown in blueprint…
-
Word wrap on rows
It would be great if model builders could enable word wrap on rows as well as columns. It would be even better if Anaplan could dynamically check each row, see which rows required wrapping, and only increase the row heights of rows where wrapping is required.
-
Adjust row heights for list or line items
It would be great if model builders could define row heights for list items or line items when pivoted to rows. This could even be controlled within another module. For instance, a model has one list Countries. One module would control the row heights of Countries, contained within a line item Row Height. Another module,…
-
How to Lookup in different dimensions
Hi everyone, I have two module. I want to post values from a module that does not have a date dimension to a module that has a date dimension. Also, there are two target Line Items. The mounting image is as follows. I would appreciate your advice. Best regards.
-
Filters
Hi, I’ve built a filter (boolean) consisting of 3 levels with dependencies. If I choose an item in level 1, I will only be able to select items in level 2 that are dependent on the selection done in level 1. Same relationship between 2 and 3 as well. This works well downwards but not upwards. When I delete (leave it blank)…
-
Simple seasonalization question
I am having trouble interpreting Anapedia's Time Aggregation functionality which states that: X = YEARVALUE(Y) * Seasonality% Will allocate Y according to a seasonality percentage (not shown). I have the following simple example with three modules: Annual sales by product group and employee Seasonal percentages by product…
-
Excel '^' Operator in anaplan
Hi Team, I need an help in using '^' operator(in excel) into anaplan, while looking through all available operators and constants I could not find this operator. Is there any alternate function for this? Thanks & Regards Madhu
-
Numbered list import error
Hello Friends, I was trying to import values into numbered list, I was thrown with this error. Please let me know, where I was wrong. Regards, Sravan.
-
Need assistance in Formula
Dear Friends, I have some products and each territory allocation. I want my final module to look like M-1 I have attached .csv file (P1) for reference Regards, S K
-
How to plan annual values -- a beginner's question
Is it possible to directly plan annual values only using calendar type Calendar month/quarter/years? I have completed the Level 1 modeling course and all the examples there plan on the basis of individual months (Time being placed in the columns of the module definition) so I am very much feeling my way on this. Here's the…
-
The filter dialog for percent formatted line items should display a % after the filter value
When you're entering values in percent formatted cells, unless there is a % in the cell, the value entered should be a decimal to show the correct value, e.g. 0.5 should be entered to display 50%. When setting up a filter on a percent formatted line item the value to filter on does not have a % therefore I would assume I…
-
Formula Summary type on LOOKUP or OFFSET
Hi, We are a NZ Telecommunications company. We have the need to report metrics such as ARPU $ (avg revenue per user) and Avg cost per user across our segments. I can do this compared to our forecasts & budgets easily but if I try to do this for Prior Year or prior period data I am stuck for a solution. I cant use formula…
-
Level 1 Model Building not a recognized line item or list member
Hello, I am trying to add the below formula and I am getting this error.
-
KPI's calculation in NUX
Hi Team, Can you please help me understand how are KPI's are calculated for a line item. It is not giving me the first data in the grid, neither the average or the Sum. I wanted to understand how is it calculated. Thanks, Veena
-
Fixed Export Destination
Hi Team, Is there a way that I can set a fixed Directory destination for an Export Action? I want to always extract to the same directory so the data can be referenced by an Excel Macro Thanks Mark
-
SUM function based on User-specific filter
Ok, here's the situation: - I have a transaction module - The transactions are children of Cost Centers - The transactions feed into a reporting module using a SUM function - There are certain "special" cost centers that exist across different functions\parents in the Cost Center list - I need to be able to give the users…
-
Tracking employee\asset moves
I'm looking for a way to track employee movements. I have a transaction table to that includes Employee Number, Cost Center and Month values. Is there a way that I can look up the Cost Center that was assigned to an employee from a previous month? I know there is a PREVIOUS function that can pull numeric values, but wasn't…
-
Workspace Naming Best Practices
Hi, We have over 1/2 a dozen workspaces. Are there any restrictions to the naming conventions for Workspaces? I know we'll have environments for Development, Test, UAT, Productions, etc. What are the best practices for naming Workspace environments? Are there character limitations? Thanks Daniel
-
Does anaplan have any plan to expand Pivot max number of dimensions
Are there any plans to allow more than 3 dimensions in a pivot, I have a situation where that would be required. Or are there any work arounds? thanks
-
Is Anaplan’s New User Experience Right for My Organization?
If you attended Anaplan's CPX conference last year, you've probably already heard about and seen Anaplan's New User Experience (New UX). After seeing a demo or two of what is possible with the New UX, you are likely wondering, “what else do I need to know before implementing the New UX?” To help shed light on this, we've…