Hi, I have a requirement where in if user selects a Boolean(Show Ending Balances) then it should show only ending balances (which is a top level for L1 description types of list) along with Ending Bal…
Hi, I need to retrieve the historical sales based on the selected Store from dropdown list of my module. Here in Module 1, the Store List has no sales for specific SKU that is why we're going to get t…
Hi all, Hope someone can help me I have a 2 grids connected and set with restrictive access, What happens: First: When I select the country (1st card) to be updated on the graph (2nd card). The select…
Hi, I'm trying to create a formula where it will create a % based on taking my States List parent by each individual state. The formula I have so far is Total Collections / Total Collections[SELECT: S…
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that show…
Hi everyone, I have I doubt which is if it is possible to add a column or more to a certain module in order to know for example the difference between the revenues in FY20 and F21 or a ratio that show…
Hello fellow Anaplanners, I have a query, I was going through an existing model and where I saw there are multiple composite hierarchy built having just 2 lists. i.e one is parent list (say 'X') and a…
Hi, I have a module where users create New Cost lines. Since the security is based on Groups, users can see costs created by other users within the group. Now the ask is that users should see the cost…
Hi I have an Emp List. An employee can have 2 records in the list (the 2nd one with an extension ABC OR). I need to pull the values of the 2nd record in another line item of the 1st record. Could you …
Hi guys, I am trying to create a calendar. In this calendar I need to pull out the first working day after day X. For example : I have a module with holidays, working days etc. as booleans and on the …
I'd like to know the difference of Summary settings combination in the blueprint view between: Summary- Formula, Time Summary: Same as main summary vs Summary-None, Time Summary: Formula If possible c…
Hi, The above are currently in the system where L4 is a list of distributors. I do not want to touch/amend since i am new to Anaplan and do not want to mess up anything. I created a new list as below;…
Hi, i'd like to ask about how to apply different formulas on each item in a list. As You can see, Module 1 shows actual data from the current month. Module 2 is a forecast module, where the baseline c…
Hi, I'm trying to convert Open date line item- text formatted in to Date using Date function but getting blank in Date Final line item, could you please help me where I'm doing wrong
I am working with a system that calculates what payments should be, then when the actual payment is made we record what that value and save it back into the model. Sometimes there are retroactive chan…
Hi! Not sure if the subject header make sense but here it goes. I have a existing module that have pricing by distributor by month by SKU, example and lists used as below; Different distributor will h…