-
Collect() function results zero values - why?
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 module, unfortunately I see zero values after using collect(). Can you help me understand why? Thank you. Best regards, Dominika
-
MAX MIN based on Multiple dimension
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 there any way the output can be achieved?
-
Import user list with a button, dev model vs Production model
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 with a button in a dashboard in the dev model, so I created the action. But contrary to a standard import, with this button…
-
4.6.4
Hello! For some reason the downloaded data file "countries.csv" will not populate into my module. Please advise. Thank you!!
-
Help! Activity 8.8.4
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 was shown on the video as well. Any suggestions? I have included screenshots.
-
How to set up time filtered chart to automatically update when model time period extends?
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 boolean for all time periods as "TRUE" > publish the charts > apply filter logic). However, the time periods for these charts…
-
Post transaction after 2 working days
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 module after two working days. For e.g. Monday, 1 March 2021 collection amount will be posted on Wednesday, 3 March 2021 and…
-
Handling dummy levels in a Composite Hierarchy
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 this means that I have had to create a lot of dummy levels to balance out the hierarchy. Example: Hierarchy…
-
3.3.6 Activity: Test the Shipping Cost Formulas
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 direction? IF Confirmed PO Delivery > 0 THEN POST(Final Shipment Amount, 1) ELSE 0
-
Level 1 - Lesson 13.6.5 - modify graph in UX
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 thanks Rachael
-
Level 2 Sprint 3.3.5.3
Hi, Why is the Suggested Order Amount for the Month line item be off by 2?
-
Ranges/allowable values for number input
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 the range of 0-10 This is like a dependent drop-down list, however now restricting the number formatted input.
-
Data format change from List to Text
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 the value from SKU Config Group column into Config Group. The reason being there are formulas already buit in the modules…
-
SUM by Quarter
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 has three dimensions: Target module where sum of milestone values need to be calculated has two dimensions: NOTE: Neither…
-
2.4.6.1 Create AD01 P3 by Account by Week 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 module. I did a select the correct item under the write access driver column within the DEM03 Demand Forecast module
-
Convert Text to Date Time format
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 format and post this need to convert it again into IST or other time zone format. Kindly help here. Example: Source date…
-
Level 2 - 2.3.8.4 Activity
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 weeks. However, it is reflecting the same monthly value across all of the weeks. Maybe i'm missing the intuition behind…
-
2.3.11.2 Create Saved View
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?
-
2.4.4.1 Update DEM03 Demand Forecast Module
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 more simple and it made more sense, but it was way off. IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'DAT03…
-
DEM01 Sprint 2
I'm trying to import data into the model but the data imported is wrong. Not sure what the reason is. PFA screenshots. Thanks, Dora.
-
FIRSTNONBLANK() as a Function
Add a "FIRSTNONBLANK()" function that will evaluate each of the arguments and return the first one that is not blank. This would allow for formulas like the following to be greatly simplified and potentially better performing: Example 1: IF ISNOTBLANK( line item A) THEN line item A ELSE IF ISNOTBLANK( line item B) THEN…
-
Time Function
How can I pull quarter values (Q1,Q2,Q3,Q4) from Expected Invoice Date ? The module has no time scale applicable. NOTE: Time Settings doesn't have quarter totals enabled .
-
Conditional Formatting on LISS
Hello, I created a module that has a lot of line items and corresponding values in 3 Versions (FCST, Budget, Variance). I need to mark the Variance column in red when the Variance has minus value for a subsequent line items. PS. Variance is part of LISS from source module Can you please suggest me what I should do in this…
-
Level 2: 1.5.6.1 Activity
Hi, I am having some issues uploading the data file for this particular activity in Level 2 (1.5.6.1). i have provided screenshots below. I am getting an "invalid line item identifier: Volume" message. The data file that I downloaded has decimals going out to 8 decimal places (screenshot below). I formatted the number so…
-
Level 2 Sprint 3 INV01 Beginning Inventory
Please refer my Screenshots. I am unable to deduce why except for week 1 , no other cells are getting populated when I use the formula "IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN PREVIOUS(Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory". Could this be backtracked to…
-
Copy dates between List items
Hi, I have three line items: Actual , R1, R2. Actual has data from Jan to Dec. I want to copy Actual data into R1 from Jan to March and April to Dec empty for input data. I want to copy Actual data into R2 from Jan to Sep and Oct to Dec emtpty for input data. This action starts my budget. It would be great to start this…
-
!!! Stuck on 1.5.6.1 Create Historic Volumes Module !!!
Can someone please show me the exact mapping that needs to be done for this exercise? I have tried this several different times over the past several days and I am still stuck on this. 😑 Any help would be greatly appreciated.
-
Users List-Workspace Admin
Hey guys, Got a query, i have a module with Users and Business Line and boolean line item which enables each user to a business unit. I published the same on a page but users without workspace admin are unable to view the users list, is there a way to make it enabled for them ? Or a workaround for this issue ? Thanks
-
3.4.4 Activity: Create Stock Exceptions Review UX Page
Hi, I am currently on the Anaplan Level 2 Sprint 3 and doing the 3.4.4 Activity: Create Stock Exceptions Review UX Page. I have build the 1st 2 grids using the INV02 module, but not able to create 3rd view for SKUs. If i am trying to create the 3 grid view using INV01, i am not able to use context filters that would change…
-
Level 2 - Sprint 3 - Activity 3.4.4 Exceptions Review UX Page
Hi All, Need help with Exception Review UX Page build query - The third grid in the page is based on Module INV01 Inventory Ordering. Problem I see is, it does not sync with Region context selector in the UX (Country and Region dimension not in this module). I thought of applying a country filter perhaps, but how do I back…