-
Filter for YTD
hi All, May I ask a question or a reference on how to create a filter for YTD. so the condition is when user select a Month > Jun 23 then it will display Jan 23- Jun 23 of the current Year. I was only able to make the filter for current month plus 3 previous months with the help pf an expert here. Appreciate your time and…
-
3.3.5.2A Beginning Inventory, Forecast Demand, and Suggested Order Line Items
Time scale issue can't get to IF 'SYS01 Time Settings By Week'.'NOT First Week of Timescale?' THEN 0 ELSE 1 DAT01 There is no time scale INV01 dimentsion by week, How do I get to part of formula to reference week ? There is nothing in SYS01 that allows me to select “First Week of Timescale”…
-
Not able to access workspace
I'm not able to access my company workspace with my anaplan credentials to complete Level-1
-
SYS08 Roles importing data
I have been working on the test activities 4 and 5, I have built List: Role and imported data, I have built Employee Drivers by Role and imported data, Added lines to SYS08 for Bonus, Car, Phone, Medical and Role. I can't seem to get the Role to populate. Department is a list of E1, and Role is a list of Role. Have been…
-
For how many days workspace is allotted to model builder?
I have complited 2 month I am completer 50 % of L1 modal
-
L3_No location data for accounts
There is no location data available to link to accounts (Level 3) and progress user story 1.4 I have seen this topic elsewhere with no response - suggest making this clearer as it prohibits people from completing the training for no reason
-
Level 1 Activity 4 - Input Role to SYS 08
-
SYS08 Employee Details from Employees
Can someone let me what I am doing wrong? I cant import the data correctly.
-
Model Building Level 1. lesson 9.2.5 updating unit cost % to 5% not able to do
Hi I am following lesson 9.2.5 - activity where I am asked to update the Unit cost % to 5% in Rev 04 module. I am trying to update the % from 0% to 5% and am not able to update the cell. how should i update the percentage value? Is it not to be from grid view?
-
L3 sprint 2 2.3.1 QUO01 Territory Account Validation
Hi everyone, I am a bit confused and have been stuck for a while, how to approach the line :" Assigned>1?: Is the account assigned to more than one territory? " also, what is the purpose of "cf_account" line? which modules should I reference? any ideas? Thank you!
-
functions
As anaplan does not have builtin function to give you the current date and time.Can someone tell me the ways to capture the current date Appreciate your response
-
Level 2 Conclusion : Importing from DEM04 into DATA02 SKU Volumes
Hi, I'm not getting errors as such but instruction says that there should be none ignored but in my case there are values in ignored. Can anyone help e find where I went wrong. Regards, Rajat
-
PREVIOUS FUNCTION, summary issues
Hi all, I am having an issue using the PREVIOUS function. In this project I have a timeline split in quarters, semesters and years, thus I should be able to see the values from the previous quarter, semsester and year in the line item called "Previous period". It seems to be working for the quarterly values while it fails…
-
Level 1 MB Exam - Error in Activity 4 - Please upload the correct .CSV file
Hi Community, I faced an issue while attending my Level 1 exam in Activity 4. while importing the file. the .csv file (in the column headings it is showing " comas in first and last columns which is crating error while running export the file) itself showing is an error. however i resolved by editing the file then run the…
-
Level 2 Sprint 3 3.4.4 Activity: Create Stock Exceptions Review UX Page - SKU Missing Only Products
Hi, I am not able to allow SKUs in the Stock Exception Review to show up, as shown in the screenshots attached. Instead of SKUs showing up, I could only allow P1 Product Family: chocolates, Sours, Taffy, Fudge to show up. What I did in My Page was that I selected INV02 Country Summary Module into the grid view. I am not…
-
2.3.9.1 Import data into DAT03 Historic Volumes module
Can anyone help with the date format for this Import ????????YY
-
Anaplan functions
I wanted to pursue career in Anaplan. I really need 10-15 functions/formulas which we frequently use to build a model. Appreciate if someone provide me links with examples from interview perspective. Thanks!
-
A doubt in functionality of "ALL" function
Hii Community, Here, Source module contains Employees Dimension, Department and Country as List formatted Line Items and Bonus as Boolean format Line Item as shown below. Target module contains Country as Dimension and Employees with Bonus as a Boolean formatted Line Item as shown below. When I am using "ALL" Function here…
-
2.3.8.4 Create DEM02 Volume Growth Rates by Week module
Hello, I have followed the instructions in "2.3.8.4 Create DEM02 Volume Growth Rates by Week module "and used the formula WEEKVALUE('DEM01 Volume Growth Rates'.Growth %) but the values are zero after using the formula. Not sure whether I am right or wrong !
-
Issue with download SUM Demo Model
Hi, I'm trying to import model 'SUM Demo' Model into my workspace but I can't find it. Can you please help me? Thanks, Ana
-
Error in level 1 Activity 7.2.3 : Unable to Import Name, Department into Employee Details Module
Hello Anaplan Community, I am stuck in level 1 - Activity 7.2.3 : Import Data into Employee Details Module. For some reason, the Name, Department, Country cannot be imported. Could I please get some advice on how to resolve? Thank you!
-
How to calculate variance by subtracting actual and forecast data ?
-
Issues with L1 8.5.3 data download
Have gone through this several times. Have changed current date in the Time list to 20209Have tried with date set at 2019 as well), in mapping have source as Column Headers -> Time, Fixed Item Location->G3 location, Fixed item P2 Products->P2 products, Fixed line item. Row and Column are adjusted to 2 and 3. Time is listed…
-
When i click on the free trail registration link its not open getting error please share a link
-
Level 1 Model Building Exam - Model Building Activity 6
I am trying to answer question 7. I am stuck on the values I am seeing me Bonus values. I have back tracked, having a tough time seeing where my numbers turned small values. Any help or guidance you can provide would be much appreciated. Thanks! Mike
-
Shipping time weeks
'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] After applying this i am not getting data populated in shipping time week line item
-
Data integration and data connectors
I am new to Anaplan have completed level1 and level2 since I am beginner, can some one provide links or articles to understand data integration and data connectors in Anaplan. Thanks!
-
2.3.10 Activity: Create Demand Forecast
Hi all, I'm stuck on this activity, I'm pulling through a 0 value for Default Forecast on Week 6 FY21 and the answer is suppose to be 73.48.. I'm not sure where I'm going wrong, I may have used the wrong formulas in DEM03. Can someone please point me in the direction
-
MR question
Hi Community, I have a bit of a problem with my MR the filter was resolve by comments from BrunoRodriguez but there is still some issues present. Requirement: When user select Dec 22 on the page selector, the graph should show Dec 22 Nov 22 Oct 22 and Sep 22. It is always current time and previous 3 mos. Example: this one…
-
MR editable selector
Hi Community, I have a quick question. I need to make the published selector editable (with red marker). This is in the MR. Source Module: Is this not allowed in MR only in UX? Kindly provide some enlightenment on this matter. Regards,