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 consi…
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 …
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 …
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
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 …
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 p…
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 crea…
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 …
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 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…
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 Regi…
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 get…
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.
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 …
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 p…
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 t…
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.
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 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 fr…
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…
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 …
Hi I have a config module(Config Module1) that contains key-value pairs with start and end dates. For example customer_id (format = text) customer_name (format = list formula = finditem(list1, custome…
Modellers Forum - next week! If you haven't joined already - please do think about joining the UKI Modellers Forum group - a great place to hear directly from Product about latest releases and roadmap…
Hey guys, I am new to Anaplan. In the level 6 of the model builder 1 course, I accidently added time in my system module. I later realize that in level 8 that I was not supposed to do that. I know tha…
Hi Team, I hope you can help me with a step I am struggling with. I have Module that have 4 years "Raw Data - Module: Data 00 - All T&E" for Transaction detail (using an Index as a list) and it has ma…
DON’T USE SHOW/HIDE FEATURE ON PRODUCTION LISTS We recently had faced an issue – On the dashboard there was one production list (Let’s say P1) as one of the dimension of a module. We had created a sav…
