Hi team! I have never used the MIN function or aggregation in anaplan before and I am having some problems now. Sorry if the solution is too obvious. I have module with Plan 23 / Plan 22 lineitem with…
Hello, this is my problem. I import a file in my STG03 module, dimensioned by the STG03 contrat list. This list has a property "Tiers" which contains the tiers names, in TEXT. I also have a Tiers modu…
Hello Anaplan Community, I'm currently facing a challenge with aligning the payment of Objectives Bonus in our model with the anniversary dates of employee entries. The requirement is to pay the bonus…
We want to get the End date but it should only fall on the weekday, we have tried other workarounds but it didn't work as intended. See screenshots fyr. END DATE (working days only) = START DATE + Dur…
Anaplanners, I would like to have a time range in a granularity for less than a year. Somewhere between a month or a Quarter. We have a business requirement where we have to import and export working …
Hello everyone, I'm asking some help. I have a numbered list "CA0" : This list has two propreties : I want to use the propertie "CA2" in a dropdown list. Here is an example. I create a moudle with two…
For actuals months I am calculating a 3 month moving average of percentages across several dimensions. For forecast months I want to repeat the results from the final month of actuals all the way to t…
I am currently at activity Level 3 Sprint 1 5.2 but looks like I still don't have DAT.01 module. Can anyone tell where can I find details for building this module? Did I miss anything?
Hi guys, So I have a question and I hope that you can help me. I have a workspace containing many apps but its name isn't really relevant. Same for some of the apps within this workspace. I want to ch…
Anaplanners, Good day ! We are stuck with this peculiar ask from the business and need some guidance on how to proceed with the same. We have a resource planning use case where we have data of the use…
I have a group of different products having different quantities and want to bundle them in to groups summing up to 10 as close as possible. For example, below I have 11 products and I want to break t…
I am importing multiple instances of Leave in module. i used select function to get them into module. Now to allow them take maximum 40 days cumulative in a year, i want to store them in single line i…
Hello everyone. I hope you are doing well. I was wondering if someone could help me to design a line item in a module dimensioned by time which generates these numbers from the first column to the end…
Hi everyone, I have an issue related to the creation of a conditional formatting formula line item based on a Hierarchy List with more than 2 levels (in this case 5 levels). How is it possibile to cal…
Note: The action was working fine since a year and suddenly mapping is gone due to has numbers as source . I have a module where I have a saved view to import data in another model . The line item nam…
I am trying to build a model that looks like the above screen shot. Tier 1 - Tier 5 are list items and everything in the top row are list items. I am having trouble getting any ending balance to work …
Hi, How can i calculate the quarter that will fill my ending on hand? Example : I have an ending on hand on Q3 fy20, i need to show in my Output Cumulate the summation of my Q2 fy20 and Q3 fy20 only o…
Hi Community, We have been working on copied model and trying to replicate the same line items and formulas as well wherein we are facing an error wherein it is reflecting Line item is not identified …