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…
Is this correct? I followed the directions and wrote the formula into the AD01 P3 module as indicated (screenshot below). However, I am not getting the square check boxes in the DEM03 Demand Forecast …
Hi All, I have a simple one to ask. Source system is sending a date value which contains both date and time and it is storing in Anaplan Text line item in a module. Need to convert this text to date f…
I used the following formula to return the monthly value to weeks; MONTHVALUE('DEM01 Volume Growth Rates'.Growth %). I would have assumed that the monthly figure would be divided by 4 for each of the …
Does the below screen look correct? I placed SKU and Accounts as pages. However, the directions do not mention anything about those two dimensions. Should i be leaving those out of the saved view?
Hi, for level 2 (2.4.4.1) I know the formula for the baseline forecast is the following. However, would someone be able to go through the intuition behind this with me? My original formula was much mo…
