How can i pull a data from a module with time dimension to target module with no time dimension using a finditem mapping made in the source data? To illustrate, my total sales of 1,000,000 was divided…
Hi Team, Inserting formula for a boolean line item as: IF Override? THEN Final Forecast = Override Forecast ELSE Final Forecast = Initial Demand Forecast Error is throwing as "Circular references:Over…
Hello everyone. there is a small question - the forecast demand field in my model is different from the screenshots in the tutorial. Was it me wrong in the formula? baseline forecast formula: IF NOT '…
I'm trying to find the reason why my number for Final Forecast (for All Accounts) in Week 3 FY20 does not match Initial Demand Forecast number. I attached the screenshot from the page.
Hello Anaplan! It will be very helpful to bulk updates in the Actions settings. In particular, the setting "Clear target prior to import" to "Only update imported cells" in 100 items at the same time,…
Hi there! I would like to know how can I change one settings characteristic in my Actions. In particular, would be to change from "Clear target prior to import" to "Only update imported cells" in 100 …
The profile function is great when you want to calculate data from a start month for future periods, it would be great if it would also work to profile data going back in time from the start month
Hi, I want to do like this table "temp2" Lineitem searches the days from now to next temp1. Time2022/1/12022/1/22022/1/32022/1/42022/1/5 temp1 ☑ ☑☑temp213211・・・ Is there any function like this?
I have a Text URL line item in a module. I want it to display on my page when a condition is met, e.g., if Employee Name is not blank. I have a filter in the view, so it will not display a value for t…
Good evening! Please see my screen shot below. The training asks us to do the following: Create a new saved view: * Filter: Forecast Months only * Saved and name the view: Forecast Periods My apologie…
Hi All, Can someone please put me in right direction, I am unable to map data from Employee+details+by+Role.csv. I have selected options in the screenshot but it does not update all records and ignore…
Whether you’re disabled in the arms or hands, interested in preventing repetitive strain injury (RSI), or simply want to get more work done while pacing around the office, today I'm sharing my tips fo…
Hi Everyone., I have a module that is dimensioned by Product List. Two line items are added, one is Product List formatted, while the other is text formatted(this is not dimensioned by Product). Produ…
In classic, when I make changes to a dashboard and try to close the page, I am given a choice whether to discard or save the changes. Perfect. In New UX, i have lost major edits without realizing it b…
Hi , I have module with number list dimension and a hyperlink line item . User can click on each link and download the PDF . But is there any way that user can download all pdf at once . Thanks in adv…
HI Community -- I have a column (text) that returns either a value off 1 or 0 . but I want to create a column that actually creates the corresponding value . For instance is the value is 1 then its Di…
Hi, I am at level 2 model building where I would need to create a UX page. one of the requirement is to "create stock exception count by product SKU and total for parent product at monthly, half year …
As a Model Contributor myself, I would love to meet everyone else who's on the same journey so please tell me more about yourself. Here's who I am: * Name: Beauram * Current Company: Anaplan * How lon…
Please advise in my DATA02 looks ok: below I am worried that I have sparsity here compared to screenshot of check build; my totals are the same though thank you
Hey Community, I tried different ways to import data, but still i am not able to match code , can you please help me out. I am attaching screenshot below.
Hi, I'm trying to check if all the info are correctly filled in , I mean the line items used (format as list) are correct? I used ISBLANK function, but seems it's not correct when I'm changing the cur…
I can't import the Pricebook.csv data into my plan successfully. I have attached screenshots of my mapping which was done exactly as the example screenshots in the 8.5.2 Activity. Any help would be ap…
Hi Team, I have registered for free trial access but still I am not able to access workspace. Could you please help me to set my access for Workspace so that i can start working on my certification Th…
I have been struggling with my formulas and I just wanted to check that my Forecast cf formula was correct. It worked the first time which made me nervous. The instructions are: * If Initial Demand Fo…
Hello, Which formula should I use in order to bring the correct Currency based on the Company Code? I try with FINDITEM and LOOKUP functions, but I guess I'm doing something wrong, as I have errors. T…
In the Time setting of the model, I just updated the current period to Jan FY22. The Current Fiscal Year still shows FY21, and I don't seem to have an option to change it. I'm not sure if it is doing …
Hi there! I've uploaded the file as per the exercise, changed the date to the MMM-YY format. It says 96 items updated. However, the module is showing the value only for January. Please help me with th…
I am trying to develop calculation formulas for the REP04 Employee Expense Summary, but keep receiving errors and incorrect numbers. I posted each of my attempts with screenshots of formulas and resul…
