-
LI PY Country and Product Family Sales
Hi, I have been stuck on this problem for quit sometime now. I know my formula is correct and my dimensions of mapping between my modules are correct, so I do not understand why I'm still getting a dim error when conducting the following formula below. Please assist. Formula: 'DAT02 PY Revenue to CY'.PY Revenue to…
-
Use Page Selectors to Select Data for Export via Export Actions
As an End User I need to be able to select data for exporting using Page Selectors in the UX, providing a common navigation experience for interacting with data in Anaplan. Currently to select data for exporting I need to use selection criteria (Booleans or List Formatted Line Items) to select what I want to export. It is…
-
Anaplan Cloudworks License
Hi, Do we need a separate license for Anaplan Cloudworks or is it part of our existing package? Also can we use cloudworks to directly integrate with Big query? Thanks
-
Subsidiary View List Drop down
I am creating a subview drop down list of a products view so i can easily select one of the items in the list. however, when i go into the subview to select the item, nothing appears for me to select. i have removed all applies to and switched the time scale to non applicable. i have this same line item in another module…
-
NewUX view Source Module
In the NewUX, you cannot go directly to the source module. When selected it takes you to your default dashboard page in the classic version. This is not helpful for users that aren't model builders with access to everything. This functionality and the Drill to Transaction is needed in order to make the NewUX functional for…
-
NUX : Selector - Equal treatment of direct change and hierarchical filtering
There is some unconvincing behaviour regarding the difference in handling of direct selector changes and selector changes as a result of hierarchical filtering. There is a hierarchical structure consisting of G1 Region, G2 Country and G3 Location. There is a board page like this one, on which two cards are placed. The…
-
TAR01 Level 3 Model Building
Hi, Would like to know if my DAT02 Formula and Dim are correct. I'm not able to LOOKUP or SUM in Country and P1 Product Family into my TAR01 Module and it is saying because Dimensionality. Below is a screen shot. dim is A2 Account>Product Thank you
-
How to estimate the size of a model
Hello, I would like to find an app to estimate the size of a model I can't find it on the App Anaplan Agile THank you for your help
-
Calculation Error for Formula
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 2 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Data import
How to import data from FY21 (datahub) to FY22 (Spoke model). Any inputs would be highly appreciated.
-
if formula question
I want to make if formula.. if 値変更入力欄 have values(not blank), show 値変更入力欄's value else(値変更入力欄 doesn't have value) show 前回値's value how can i make this formula? please help me...T-T
-
Level 1 Model Building Activity 5/6. Super Stuck - Need Help
I am trying to calculate the phone costs for a department in December 2020 and medical costs for a department in December 2020, as well as fiscal year totals for certain departments. Been on this for 1.5 weeks now. The formulas I am using in REP04 are producing numbers, but they are incorrect. Here is REP04: It draws from…
-
Level 3 Model Build TAR01 Module/SYS03 Module
Hi, I'm having trouble with putting together the TAR01 Module. I understand the task is to get the Total Revenues of my Products (P1 List) by Country and it's "Children" (G2 List), and then fine the percentage of that by dividing by total annual revenue of a country (Total Annual Revenue by Country and Product / Total…
-
Formula Help
Hi Everyone, I’m trying to do something really simple but failing. I’ve got a list of loans and each loan has a starting date. Interest is payable every x months from the starting date. I want to create a Boolean every x months from the starting date. How do I do this? I can put a boolean in the first repayment date but…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Please suggest the process to avoid the errors...see the screenshot attached.
-
Another row has already been processed with this key
Is there any way to suppress messages after importing into a List that are a result of the 'Another row has already been processed with this key'
-
Rgarding the anaplan workapce models
Im done with the level1, level 2 sprint1,2, and 3 including conclusion also and left with the updating the history of level2 supply chain but in my workspace ,my models are not showing the models and states no model yet.... can anyone suggest what to do now...Hereby i'm attaching the screenshot also... Thank you...
-
Using Excel function in Anaplan
Hi, My question is There is a Function in Excel and there is no similar kind for function in Anaplan, so how to in cooperate that function in Anaplan Regards Surya
-
How to automate subsets
How to ensure your Center of Excellence keeps on top of subset management One of the easiest things that can go wrong in a model is when subsets get out of sync. In larger models you may have multiple subsets on large lists and keeping track of them all can quickly become very difficult. For example, what happens when…
-
SYS08 Region and Role
Hi - I am trying to bring in Region and Role. I added them as a line item in my module: Here are all the modules: And here are my lists: Can anyone help me with how to write a formula to bring in Region and Role?
-
L2 Conclusion - Create Shipping Export Module -
Hi everyone, I am on L2 Conclusion chapter. I have created the formula to populate Shipping cost. Please see below formula . As long as I understand the formula is correct but the aggregation i am getting is not correct. 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] Plesase…
-
REP05 Local Currency P&L
Hi Can someone help me where do we find LIS REP03 P&L:Items while creating a REP05 module. I couldn't find it in lists and roll ups columns even though I have created line item subset.
-
Bringing in Roles - Formula Help
Hi - I am trying to bring in Role. I added them as a line item in my module: Here are all the modules: And here are my lists: There is a dropdown for me to manually put in the roles, but I just don't know what to do for the formula. Can anyone please help me with how to write a formula to bring in Role?
-
Deleted model
Hi, I have 2 questions: -I accidentally deleted the model i worked on during the course for level 1. Do i need this model for the exam? -When i try to start over the course from scratch for practice purposes, the model I download from chapter 1 already contains data? Can someone help please. Thanks, Jacob
-
How To Convert Infinity, -Infinity, NaN to Zero Value
Sometimes in the numeric formatted cells, as a result of various calculations, it is possible to have returned as a result the Anaplan special numbers: Infinity, -Infinity, or NaN (Not a Number). If the numeric line item with this issue is also an input for other formulas, the final result could be altered. To solve this…
-
UNDO Action
What are the ways to implement "UNDO" action/process with a help of a custom created button on dashboard in Anaplan? This UNDO button would reset values of cells to it's original initial value.
-
Date Conversion
I need to convert the text formatted data below to the date format 03/08/2022. I have a formula to do that, but the time stamp on the right interferes with my formula. How would I remove that part of the cell? Or how would I add it to my formula: DATE(VALUE(RIGHT(As Of Date, 4)), VALUE(CODE(FINDITEM(Time Conversion, MID(As…
-
Use formula « NAME » for a Number list
The NAME function always returns the #ID and not the display name. I need another function that could returns the display name. If this function doesn’t exist, I’m looking for a solution to switch from a list format to a text format. So I’ll be able to concatenate. The difficulty is: the format list used is different from…
-
New UX: Column headers hight
This is not quite the same idea of my colleague, but it has some similarities: https://community.anaplan.com/t5/Idea-Exchange/New-UX-Column-Headers-Wrap-Text-by-Words/idi-p/99307 In classic UX we were able to select number of lines of the headers of a module on a dashboard: It will be nice to have it in NUX also, or any…
-
How to cascade a year boolean into months?
I have a boolean that allows users to select if they would like to add a price adjustment by years. If a user selects that they would like a price adjustment then it should apply to all months within that year. I have another module by month where if a user selected to add the price adj boolean for the year from the…