-
How to get an average time difference between dates for a particular month?
Hi Community, I need to use the difference between 2 different dates B-A & then get the monthly average of the difference for the month B in anaplan. Sample Data is mentioned in the Table below. Average for month (based on the Diff.) Month (Based on Date B) Diff. (B-A) Date A Date B 50 Feb B1-A1=x1 A1 B1 B2-A2=x2 A2 B2…
-
Can you scale the X-Axis in a graph/chart if the X-Axis is the Time Dimension?
Seems like in the New UX graphs and charts axis's can be scaled if the axis is a line item. However, there should be an option to scale any axis even if it is a dimension especially Time. For example, daily data would look neater and present better on presentations/decks if the time scale could be reduced to show SOME time…
-
Handling Gap in Data Stream
Hi all, Due to a 2-3 weeks of gap in the data stream, I need to ignore the data for those weeks from all computations in an Anaplan model that is nearly 50GB in size. If those weeks remain as null/no data, those cells would still remain part of the computation particularly if the logic indicates Sum/#N Weeks or moving…
-
Anaplan-Power Bi Connection using Basic auth-Blank source
Hi, I am trying to connect Anaplan & Power bi, I followed steps metioned on Anaplan community, but I was not able to see data in Power Bi. In Anaplan I have created one test export action. In Power bi I have entered below url in next step, I'm using my Anaplan User name & Password associated with the models. but I'm not…
-
Additional practice models/builds
Hi Anaplan Community! I've completed the certified builder program, but am wondering whether there are any additional practice builds out there that I can attempt? e.g. I'd like to practice building an ICM/SPM model. Thanks!
-
List item has nothing showing in 'Referenced in Formula', but it is referenced?
I have a list that shows no references, and i was removing ‘dead’ lists however, when i tried to delete it i got an error saying it was used in a module. And after looking i found it was indeed used So why does the reference not appear in the list information?
-
Getting Monthly and Quarterly totals in Weekly model
Hello all, I'm building a model with a weekly time scale. The client wants to see the Monthly and quarter totals also. Do you have any suggestions on how to get these totals? I created time filters to get a Month and also manually did a Quarter line item. But when I do a lookup, it doesn't come through.
-
Building a Long Range Planning Model
Hi, I'm a new Anaplan user (completed L1 model builder). I'm starting a project to get our current Long Range Planning model from excel into Anaplan. This is my first project and I'm wondering whether other group members have any similar experiences. There is a template LRP model in the App Hub which I'm considering using…
-
LOOKUP not working as intended
Hi Anaplaners, I'm having an issue with IF ELSE Statement. I expect the ‘ELSE’ part to go accross opposite direction than the ‘IF’ condition. But it seems to not be working using a LOOKUP function but works with a SELECT function. I want to promote it to PROD but I can't do it with using a SELECT BUT INSTEAD A LOOKUP.…
-
User Access Between Schedules and Snapshots
I have a user who has access to schedules but doesn't seem to have access to the corresponding Snapshots. A few things I have tried so far, are: 1.) Confirm their role and that they have access to the schedules 2.) Used my account as a test account to recreate the issue. When I tried to recreate the issue, I was able to…
-
Conditional formatting between range of numbers
Hi Anaplaners, I have 5 line items (Number Formats) showing variances. I want to apply a conditioner formatting to each of the 5 line items based on a range of numbers. E.g any numbers between -1500 to 2500 should have a Green colour and any numbers outside these range should get a RED colour . Please is there any…
-
SKU to Format, Flavour, etc
Hi Guys. I have the following issue with our Anaplan implementation. Our SKUs can be rolled up either to Format (FO), Flavour (FL), Volume (VO), etc. All these have parents such as F1 > F2 > F3. The common denominator between all of them is the SKU. I have created a SYS module that has all of these as properties, therefore…
-
Retrieving user selective access in module
Hi, I have an issue in my Workforce Planning model I can't quite get my head around. The scenario is the following: I have an organisational hierarchy with Cost Centers and then Individuals as childs. I have selective access enabled to my cost center list and only certain users have access to certain cost centers (and…
-
Anaplan formula to Lookup Balance Sheet description from mapping table module
Hi Anaplan Community Please see email attachment with all details for my question. I have an “Account Major Properties” module with a line item of “B/S Line Item” where I want to populate the valid Balance Sheet line name, from the list “Balance Sheet Lines – NEW”, based on the Account Major (e.g. GL Account) contained in…
-
Is it possible to have a "Create" Action on a list with no parent?
Is it possible to have a "Create" Action on a list with no parent? If not then is there a workaround?
-
Schedules Mapped by Entity Name in Anaplan
In Anaplan, I have a schedule that needs to have the name of an entity name change to the English version. I was put on notice recently, that the schedule is being mapped by the entity name. Can anyone provide guidance on how I would be able to see in Anaplan exactly how that schedule is being mapped by entity name and…
-
Sum from a model Applies to Fiscal Year and a customized numbering list to another w numbered list
Hi Experts Appreciate your prompt help to provide a solution! We are working on Quota Management based on Territory hierarchy. In module A (Applied to Fiscal Year, Mapping List with items like PSM1, PSM2, ..PSM1600), users can assign different territories to one employee assignment (employee assignment is not the same as…
-
Sum based on Parent in Hierarchical List
Hi, I have a hierarchy of lists, L1>L2>L3. My module is dimentioned by L3 and has two line items, Input value and Input %. Input Value is entered by user. Input % = Input Value/Sum of Input Values for all list items of L3 under a L2 list item. How can I calculate this sum, as it is the sum of all items in L3 under L2 a…
-
Putting values in territory field from multiple quota assignment rows of an employee into one field
Hi Experts, Appreciate your brainpower on below challenge. Using below test employee as an example, we would like to have a field show “PKI, BCT” in the same row same cell, similar to concatenate or textjoin in excel. Expected result like below (using excel as demostration) Thanks a lot!
-
Retrieving last non zero value for daily exchange rates
Hi, I have a daily exchange rate module which store the daily rates for multiple currencies. I wanted to get the last non-zero value for each date for example we have daily exchange rates for 1 Jan 2021 but none for 2nd and 3rd of Jan 2021, so the daily exchange rates for 3 Jan 2021 should display the rates of 1 Jan 2021…
-
how it work for sales manager
how our platform work for a sales manager who is responsble for profit and loss account of food products marketing company
-
How to Auto-hide line items
I have a table which include value from Q1 FY21 to Q4 FY23 as line items, and want to hide which the value is 0. But when I use filter on line item will hide other line items like KPI Name (it is TXT format). How can I hide these line items which value is 0 and does impact other no number format line item? Thanks!
-
Display months as M1, M2 instead of Jan, Feb
Hi! My company uses a 4-4-5 work week calendar. Currently, the system shows the months has Jan, Feb…Dec. but I would like it to display as M1, M2….M12. The reason being is that our M1'23 has a date range of 12/31/22 - 1/27/23, therefore, saying Jan is misleading. Thanks for the help!
-
Can you link to a specific record on a new UX page
I have a list of projects and i have a line item that is a link to the project page, but would like to go to the specific project they are clicking on. The html for the page is the same no matter what the item, but can you add a tag to the html at all, like you can in other apps?
-
DCA by User´s role
Need to generate a DCA module that depends on users role. I have seen that there is no capability to extract the users role, any suggestions? br
-
Add List Search Option while create module and Import from Existing Model
Hi Team, If we provide a search option to select a list when creating a new module, it helps model builders select the required list. Similarly, if we provide a search option to select the source for any import from existing model views or lists, it also helps model builders.
-
Best method for Scenario Planning?
Hi All, I am currently in the process of investigating the best methodologies for building in scenario planning into one of my models. After some internal conversations and a little community hunting, I thought it would be best to write a new post. For context the model i am building scenarios into will require several…
-
Filtering based on User selection
Hi I have 4 modules, with hierarchy regions set up. All 4 modules with dimensions are described in ss. I want to apply a filter on last module for only the countries selected for particular user but I am unable to do it.
-
Planual
I am proud to announce the launch of the Planual, the first-ever collection of global best practices for Anaplan model building. Created by Anaplan experts, customers, and partners, the Planual collects a wide-ranging set of guidelines, techniques, tips, and tricks organised to help model builders avoid common problems and…
-
New to Forum
Hey everyone! My name is Chad Pyke. I just started my Anaplan journey and am excited to learn from each of you! I'm hoping to transition into a career in Anaplan/EPM by EOY and would love any advice or counsel you have on the customer vs partner track. Thanks!