Hello everyone. I have created a custom calendar. I have mapped Week(List) and Year(List) corresponding to Time(Days). I would like to create a module that sets the start and end dates to the Week(Lis…
Hi, I have a column which is made up from a List. I've created a "new column" called "Sales and Marketing" and would like to sum up the values that are currently in "Sales" and "Marketing" respectivel…
Hello Anaplanners The result of the calculation seems to be wrong. In fact is question 6 from model builder exam1. the formula should return the sum of expenses based on hierarchical level and region,…
Hi team, Are you able to publish a Line Item from a module to a Dashboard as a Page selector that will act in the same manner as the dimensions published? e.g. the line item will change with the line …
Hi, I am getting an error putting this formula to the shipping time(weeks). 'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product,LOOKUP:'SYS07 Distribution Cente…
The beginning inventory in this exercise seems off. I even checked other comments on the board and I have followed what I could. the second screenshot shows the set up for the INV01 Module for the beg…
I've always been told as best practice to not edit formulas for line items directly in the formula column of blueprint view, instead to click on the line item and then activate the formula bar on the …
Hi, I would like to add up the 2 input values from "Sales" and "Marketing" into the new column called "Sales and Marketing". The reason is because there has been a change in the categories of business…
Hi, I have created an import action from Model A to Model B and both are in same worksapce. Please see the below details of Model A & B. Model A: It is source model for an import action. I have used s…
Dear All, I have a scenario as follows : I have a Module with SKU, Company as dimensions. Sales Volume is an input. List Items in Company are GST, TMB, BCC. Now, I want the data in line items to be co…
I was going through the training module and it says we can rename Organization List by double click on that, but I am double click is not resulting anything. How can I rename it.
Hi All, We are facing a challenge in Anaplan where user edits some data in anaplan but after some time there is a scenario that user might want to revert the changes back. Currently we are driving it …
Hi Everyone, I have a question on how to do a linkage between 3 modules (Source Module, Mapping and Target) The image below is my mapping, basically, each Lane is connected to each Slottage Type based…
Hello, I used collect() function to take data from the source module. I created LISS from the source module and then used as dimension in the target module. The dimension are the same in the both modu…
Hi All, i was trying to find out Max and Min Salaries based on Country, Legal entity and Department. I tried using the Max function based on all three dimension but gave a output value as infinity. Is…
Hello Everyone, I have a production and development models. But I can't import users with a csv file in the deployed model (but I can add manually users one by one...) , so I wanted to create a action…
I am currently stuck on Activity 8.8.4. I have definitely entered formulas multiple times, but I am getting an error when trying to copy and paste the formula. I have entered it manually the way it wa…
We have several dashboards with ~30 charts all have time on the x-axis and a dynamic time filter on (trailing 13 months). The time filter is set up following the recommended steps by many users (set b…
Hi Community, I need a help to post transaction after 2 working days. I have a daily collection amount as a line item in a input module. I want to post these daily collection amount in a calculation m…
Hi Community! I have a quite large organization hierarchy (12 levels) that I´ve converted from ragged to balanced. The original hierarchy has profit centers in every level, starting from level 4. So t…
Hi, I am trying to update the confirm purchase order receipt formula with a POST function. I believe I am again, not understanding the intuition behind this. can you please guide me in the right direc…
Hello, I am practising lesson 13.6.5 to have the forecast margin in the chart. Would someone please advise how do I get rid off the full year total? And how do I add a label in the Y axis please? Many…
It would be handy to restrict a number format. This will save additional validation checks/visualizations. e.g: - Number needs to be positive - Number should be an integer -The number should be within…
Hi We have two columns in a General list ,i.e SKU Config Group and Config Group. The SKU Config Group is having format type of List and the Config Group is in text format. Our requirment is to copy th…
I want to sum the milestone values by each quarter in a different module(Line item). NOTE: Quarter period(Line item format)in Quarter line item is from time scale and not model calendar. Source Module…
