Can anyone help me what's the best way to identify - Current Year Current Quarter, Current Year Previous Quarter, Previous Year Current Quarter using DCA and Boolean.
Hi, I have a module in which I'm trying to determine if accounts are within an account list subset, if so return TRUE, so that I can then filter those records to import to another module. I cant get t…
I have been stuck on the first formula for days. When I enter it the error I get is: I'm not sure what this means, I have gone back and double checked the naming of all of my modules and made sure I w…
Hi, Section 4.5 says to check my build on the Accounts Exception UX. I am not sure if there was an activity to build that. Am I supposed to build the UX pages basis the mock-ups we created in the begi…
Hi on the Level 1 model building exam, I am trying to import the SKU csv and I get a message saying invalid parent and I dont know why. Wold you mind helping me ?
In module 1, I have a count for resolved and unresolved. In module 2, I would like the total for unresolved items and resovled items. How do I do this? I know in Excel it would be a simple sum formula…
Hi - I'm ready to take the Level 1 Model building exam. From the instructions it seems I should plan on completing in one session. I'm planning my week, how much time do you recommend setting aside to…
Hello, I can use item(user list) to get current user, i.e. the user who login current system, it requires to use user list as dimension. Now I have a module which is not dimensioned user list, is it p…
Hi I have a line item ' Transaction Date' formatted to 'Date' . Sample value : 01-08-2021. I am trying to derive the Month,Quarter and Year from this Date value in the below sample format. Month: Jan …
Hi, I got a metadata dataset for the charter of accounts that uses the same code sometimes at different levels of the hierarchy. Although this is possible/works when creating in Anaplan for both Numbe…
Hi , If we have users of around 10000000 in Sales team and we are using that list (Users) in one module so how can we optimize the structure of module as if that module page is published in Dashboard …
Hi, I have a scenario where we have created gap process to hire new resources, essentially adding new lines in our employee list. However one problem coming up is sometimes we created a gap and then a…
Hello, I am trying to solve a dilemma. I have values for a list property called "adjustments". These values can be positive or negative and there can be more than one in the same time period for the s…
Hi, I have been using the long formula for working days suggested in the Anaplan help, and it's been giving me some issues, so I created a new one It's shorter and easier to follow and thought I would…
Hi All, I am trying to solve an excel model in Anaplan where my current value is a calculation of the cumulative of previous values. The calculation works fine in excel but I am unable to break this d…
Hello, I am having troubles when I import the data from the Price Book that I downloaded from Anaplan Learning. The numbers imported are inserted with a multiplication of 100 (e.g 0.84 USD ==> 84 USD)…
Dear Team, I would like to seek for your enlightenment on this area. I tried to copied several times an amount (percentage in real number format) with a decimal places of 19-20. it copied correctly in…
Dear Anaplan Experts, Please see the pic attached. I would like to create a filter that shows items that match ALL for three boolean criteria (i.e. show the record if ALL are met) and ANY for two numb…