Hi, At the end of this lesson in Knowledge check I did arrange the Format settings as shown in the shared image below. For this selection it is showing invalid answer. Please can someone advise what i…
I have this type of List. ALLRegionCountryWorldEuropeFrance German AsiaChina Japan I want to Sum Lineitem by only Region not All, Like this Table. ListLineitem(None)Lineitem(Sum)IdealWorld 40Europe 2…
No sounds in Anaplan Level 2 Model Building: Sprint 1's 1.3.2 Import Errors's Summary sections, as picture shown where the exact part as I am referring.
I have already loaded data to the list and used in the module but when i started giving exam of sprint-2 and it has to be answered from the activity we did in the hands on. So after opening this modul…
Hi, I have to show only 1 relevant line item on the Dashboard based on the page selection. I have showed in the Test screenshot below. Like in above module if I want to show only Line item 1 if I sele…
I'm getting used to the new model experience, and overall it's a good step forward. However, I have one major frustration, which is that the formula goes straight into edit mode when I expand it out. …
Hello Everyone, I have two modules as mentioned below.I need to get data from module1 Jan20 to module2 Jan21 and same follows for other months. Module1 Time Scale -FY20(jan to Dem) Line item - Data Mo…
Hello guys, pretty sure the solution must be simple but i cannot find it. I am trying to use the total of a line item in another formula. what i have looks like the screenshot Thanks in advance 🙂
Hey Community, I love the ability to reorder lists, but I don't love that I can't enable users to do this. I have a mini- MDM project buried at one of my clients and reordering data is a very nice thi…
How do I give dashboard users the ability to run a bulk copy from a button on the dashboard? Specifcally I have a list which contains "versions" I want to make the copy of Current Month to Prior Month…
Hello All, Please note, while working on 4.6.5 Sale Planning Model: DAT02 module, below are the steps i have completed- 1. Created A2 Accounts. Product# list and updated it with concatenated codes 2. …
Hi, For your assistance please. I am trying to aggregate specific invoices and tried using the movingsum but on the last invoice cut off 4 which the number of days are variable. How can I count and us…
I am having an issue with the Role list. When I try to format the Role line item in SYS08 it gives me this error: Format of mapping used for lookup doesn't match any dimension of the source. I've atta…
Hi, want to SUM value with Month. I set the time setting as "Week General". It has no month aggregation, so I made the Month List. And I calculated month value as a described below. <Solution1> Formul…
Hello Anaplan Community, I am attempting at building a real time inventory model that has kafka and postgreSQL integrated with Anaplan and has a base code in Java. I was wondering if anyone else in th…
Hi everyone ! I am currently doing the Level 2 Model Builder, Sprint 1, and I am stuck at step 1.5.7 Basically, I need to feed a boolean Line Item called "Has Data?", which is on the SKU ; Account dim…
We're using "Week General" as Time Setting. Week General has day and week value, but does not have Month Value. So I made Month List(Jun21-Dec21), and I want to aggregate the value from day to month. …
Hello all I am new to this and want to start learning level 1 model builder. How many classes are required for it and how much is the cost? On instructor led training, it shows class registration with…
Hi All, Version as list has limitation ,,,that we can not use Switchover. Why we can not add this in scenarios? Also Why can we not use Switchover in line item to fetch a formula and scope to use it?
Hi! I have a question about this feature. I tried to figure out if it possible to send out notification to the whole department for example ... And this is what I have now. Even if I put couple of ema…
While importing Shipping Metrics.csv to module DAT02 Shipping Metrics, you may get invalid data format error. To solve the problem: simply edit the date format by Untangling Anaplan Time Mapping: to e…
I would like to request a function to get the length of multibyte string in Anaplan. In some countries such as Japan and China, users can use multi-byte characters to enter number and alphabets. Our u…
Hi, In activity 13.6.5 of the L1 MB course I am supposed to use Custom Views and use Time to filter such forecast is shown by months and FY totals. In the model view the FY totals show at the end of t…
We have a module dimensioned by Time and Item ID. One of the Line-Items in the module is Item Category. We need to identify the unique categories. ISFIRSTOCCURRENCE seemed to be the answer but it is i…
