-
Compare numbers in different modules
Hi I have a module with employee details to calculate their monthly payout. The payout is based on the % attainment stored in the same module. The % attainment need to fall in a defined range (captured in a DAT module) to suggest the payout %. For example the DAT module is as given below (not dimensionalised) The other…
-
Formula to calculate based certain items in a dimension
I am having trouble to create a formula to calculate something on selective items in a dimension. Simplified example is as follow. 1. Products A, B, C and D defined in a list 2. Clients 1, 2, 3 and 4 in another list 3. Production costs calculated at the client level based on the products (any and all) they have Now I need…
-
Sum based on Boolean
Hello, Hopefully a simple one. Our P&L has 50 cost centres, each of which have staff costs assigned. In a separate module I want to bring in the staff costs from 15 of these - is there a simple way to do this, for instance by having a separate module with the cost centres included and a boolean line item to determine which…
-
Production Data - Top level Can be Changed?
I have a scenario as follows: I have a List named "Product L1" which has been marked as production data. While I understand that structural changes can still be made to a list that has been marked as production data, I have noticed that the top level, which cannot be changed if the list has been marked as production data,…
-
Lesson 6.6.4
My module looks identical to the example, except for one additional "YTD" column. Can someone advise how to get rid of that additional column?
-
A line item format as "No Data" can be used in an import action?
Hi Guys, I have an action to clear data in target module. The format of line item in source module is "No Data" and formula is blank. And the format of line item in target module is Boolean. I want to make the value of target line item as FALSE. Does it work when I run the import action? As my experience source and target…
-
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…
-
How to get access to Anaplan workspace to create modules to practice?
-
Boolean to Boolean / Date to Date import
Friends, I am experiencing a very strange case where am importing a boolean lineitem (1 cell) to another boolean lineitem within the same module (1 cell), which has derives DCAs on other lineitems, but the boolean is not copied over (through import) in target line item; although the import process shows 1 updated. Source…
-
L3 model building sprint1- 4.6 Model Build Specifications
Hi Everyone, I'm working on L3 training and feeling stuck. in section 4.6.5 we are asked to build the module that references PY FY19 sales. I was able to do it, but on the confirmation page from anaplan dimensions look different, but the numbers are correct in total and by product. I used A1 accounts, P2 Products lists. do…
-
How to bring a territory down to account level?
Hi all, I am having trouble assign territory down to the account level. Here are my modules: Module 1: This is the territory definition module containing the attributes for my territories. In this case, I have create an territory "USA_Banking_SPC_Tier 1_Rule 1" to cover all "ABS Lender" products. Module 2: This is the…
-
Use Time dimension in a formula
I have a module with Day as the time dimension. I would like to refer to the module time dimension in a formula. For example, WEEKDAY(time dimension). So that on January 1, 2023, the line item would return 7 (for Sunday). Is this a thing?
-
Hello,
I have a module dimensioned by Accounts on the rows, Users on the columns, and 1 Boolean line item which allows users to select certain accounts that apply only for that user. I am trying to create an action that allows the user to clear all of their selection by simply clicking an action button, as opposed to have click…
-
Clear Override value when the Override boolean is unchecked
Hello All, I would like to clear the override line item based on whether the boolean value enabled or disabled. Please see screenshot attached for current & expected behavior I have perused through the existing questions on this topic but couldnt really get the same problem statement. Apologies if I missed it somewhere, if…
-
Comparing values against the same dimension
Use case: Prod A was sold for 100$ as part of Plan A, 120$ as part of Plan B and 150$ as part of Plan C, I need to determine the increase/decrease in price for each plan. How can this be achieved in Anaplan?
-
How to sync manual data to from one module to another
Hello All, I am trying to bring the data from an existing module A to another module B ( have created the same column in the module B with correct dimension), but I am seeing no data in that module Going forward i want this column to be up to date with the live data in Module A Is creating an action my only way? Approach…
-
Ratio summary not working due to level missmatch
Hello, I have a module (655) that is using summary Ratio to work around the issue with child/parent relationships and getting information into one column. I am trying to replicate that solution into another module (141) but it has an error message regarding dimension mismatch. I am having a hard time understanding why is…
-
module based on hierarchy
Hello, i want to make a module that is based on a 2 level hierarchical dimension "product". When I click the selector of a Level 1 product I would like to see all the L2 Products that belongs to that Level 1 Product. With that module I'd like to make a pie chart. Problem: I have made 2 lists: L1 Product and L2 Product. I…
-
Is a live model to model connection still happening?
A few years ago, there was a "live" model to model connection on the Anaplan roadmap. Has there been any update on whether models would speak to each other continuously versus through an import?
-
Mailto for multiple recipients in Outlook
Hi. When I set up a mailto with commas separating the recipients Outlook tells me I need to change the commas to semi colons. When I change the list of recipients in Anaplan to use semi colons as separators no recipients appear in the draft email. Has anyone else experienced this and found a solution. N.B. We have central…