-
Level 2 Sprint 2 - 2.3.8.4 Create DEM02 Volume Growth Rates by Week module
Hi Experts - I am trying to understnad the way to Get the Weekly value for the "DEM02 Volume Growth Rates by Week module ", from what I understand, based on the Montly Growth % in the DEM01 DEM02 has to sholw the weekly Growth %. And I intially tried to use the WEEKVALUE formula but that did not work and when looking at…
-
3.3.6 Air Override not showing correct figures for Nutzo Bar_EN
Hello, Below are my formulas and lists I overrode with shipping method AIR. I believe its related to way my list is setup see below, any insight would be valued. Air resutls for Nutzo Bar_EN not showing correct. Final Shipping Cost Final Shipment Amount / 1000 * 'TRA01 Shipping Metrics by Week'.'Shipping Time…
-
isblank
Hi how to apply ISBLANK in Boolean format for multiple columns. I am not getting error if it is one column but if it is for multiple columns Im getting error IF ISBLANK(Market) THEN TRUE ELSE FALSE
-
L2S3 Activity 3.3.12 Sys01 time settings by week module
May I know if I have this correct: Line Item Planning Period Filter: the formula is 'Sys00 Time settings by month'.planning period filter Line Item Planning period Filter weeks only: monthvalue('Sys00 Time settings by month'.planning period filter)
-
LM2 - Data Hub SYS13 - Formula Hint 2
Hi Team, In the Data Hub in module SYS13 Account SKU Filter you setup a Boolean line item to determine whether there is data in DAT03 My formula to be used would of been: TIMESUM(DAT03) > 0 or TIMESUM(DAT03) <> 0 The 2nd Anaplan formula hint is below: This is confusing as when/why would you use a Number (1/2) to determine…
-
Anaplan bring data to future week
Hi, How can we calculate the collection of Revenue for future week? See example below, our Week13 fy24 data is to be collected in Week18 Fy24. Thanks in advance for helping. Regards, Tom
-
Formulating and capturing the no of orders count based on orders placed between time scale.
Hello Community, Process explanation based on below screenshot is basically on the left part we have module in which time is recorded for the orders placed and we need to gather and capture the count or no. of orders placed between the time series. EX: Orders between 14-15 PM is placed at 14.30 PM and 14.45 PM we need to…
-
Question on Sprint 2 Detailed Demand Review Dashboard
Hi - UPDATE: 24 April 2019 - I had an error in one of my formulas (found out on Sprint 2 exam) that I corrected (retook test to ensure I had it fixed the issue). I had thought that by fixing that formula it would resolve the below discrepancy but it didn't. I have a question similar to this one posted in Anaplan Platform…
-
Parenth
Hi all, a simple one this time. I am trying to get the parenth member of the list. But I keep getting this error. my formula as i remember it is Parent(Item(L3 Department)). then i got an error on it Any idea what I am doing wrong. Appreciate the help on this one. Regards,
-
Account Assignment
Hello, I also have a question concerning assignment. I don't understand how it can be possible that an account may have more than one territory assignment. The account is unique and we assign a territory for it or change it but it remains only one territory by account from my understanding. Could you please explain what I…
-
My request to join Talent Builder Independent has been declined, what should I do?
Hi, I just got the Anaplan Way Course Certificate. I fullfill all the listed requisites as well, but the request to join the Talent Builder Independent Program was declined. I'm wondering if I did something wrong. Is there any chance of requesting, or getting these 90 days free trial access without having to wait 30 days?
-
How to return null value for a list formatted line item
Is there a elegant way to do that? currently i am using one column to return text value and another column to find back the item. Because it won't allow me to enter if in tier = True then Item(Tenure) else "" because "" is not in the list of Tenure.
-
workspace apply
Hi everyone, I am an Anaplan self-starter. But as of now, I don't have a free workbench. So much so that I can't do modeling etc. I hope someone who knows can tell me. Thanks to all!
-
Level 1 Model Building SYS08 Employee Details Import Issue
I am trying to import Employee details but country is not linked. Is there something I'm missing or should consider?
-
getting the error: "Dimension of mapping used for lookup doesn't match any dimension of the result"
I am doing level 1 model building(Activity-9.2.5 Activity: Add Formulas to Price Growth Rates Staging Module) When i try to enter the formula for the lineitem 'Unit Price %' i get the following error- "Dimension of mapping used for lookup doesn't match any dimension of the result" . My Formula- 'REV04 Price Growth…
-
Action for Deleting an empty row in UX after running the process
Hello community, I have been working on creation of the group wherein employees roll up to a particular super group below are the 2 Screenshot in detail. Current Process: Below is when enter all the details and click on action called "Create Super Group" the new employee with its Super Group code is added to the below Grid…
-
How to get Access to workspace for model building
Hi Team I want to develop my skill set in Anaplan, thereby want to enroll for Level 1 Training. Here I can access/look at the training content but I don't have the workspace access to build the models. Please help me with this, as I have been waiting for a long time to get WS access for model building.
-
Need 90 days trial access
Need 90 days trial access for model building and practice
-
Free trial anaplan access for practice
Hi Everyone, Is it possible to avail free trial anaplan workspace access for practice ? Thanks Yogesh
-
TAR03 Country Account Calculation
Hi @Misbah,@JaredDolich How are you? I am filling the TAR03 Country Account Calculation module. I want to know if Targets is SUM of Initial Account Sales Targets. What is the Check? Any hint/clue is very appreciated. I am looking forward to hearing from you soon. Best regards. Wei
-
Anaplan API
I am trying to use analan_api python wrapper. My goal is to see if i can automate some update and download into and from the anaplan model. Anyone has tried that before? Thanks
-
Hey I am unable to log in to workspace even though trying it multiple times.
I am unable to even change password and cannot open it please help!
-
UX Page action button and Grid Data
Hello community, I have been working on creation of the group wherein employees roll up to a particular super group below are the 2 Screenshot in detail. Current Process: Below is when enter all the details and click on action called "Create Super Group" the new employee with its Super Group code is added to the below Grid…
-
Need help in understanding the calculation
Can anyone help me understand what I am doing wrong here? As per the data files provided in L3 Technical Exam Q1FY20 Baseline value of Chocolate Product Family for US = Q1FY19 Baseline Value of Chocolate Product Family for US = 537863 FY20 Percent increase for US = 5% Initial Country Sales Target for Chocolate product…
-
The Anaplan Way Guide
I've completed the Anaplan Way Guide course, still every time it shows that I didn't. Once I complete that, I should be receiving the badge that I completed that, right? but that's not the case with my profile. Can someone help me regarding this?
-
L2 Sprint 3 INV01 3.3.5.3
All of the formulas seem correct but I cannot get Shipping Time Weeks to populate. Where am I making a mistake?
-
How long does it take to study for the Master Anaplanner Exam?
Hi, I was wondering how long it usually takes to study for the Master Anaplanner Exam? I know everyone is different, but can someone give me a ballpark answer? (Is it 1 month or 1 year?) Can anyone share their experience/ tips? Did everyone just study this material? How long does it take to get through this material?
-
Level 2 - Sprint 1 Activity 1.3.10.4 Check your work - not getting data as expected
1.3.10.4 Check Your Work After completing the import processes, the G3 Location:Distribution Center? is missing
-
Formula related to ITEM() in the same List
Hi Everyone, I am trying to summarise and collect data from numbered list input module. I want the formula in the Item "COGS" in the COA list to refer to Item "Revenue" also in the COA list but in the input module. Line item is Amount (single line). Appreciate your ideas and suggestions. Thank you
-
10.2.2 Lesson - Level 01
Hi everyone. I'm having a problem importing the data in this task. The numbers do not seem to respect the decimal places in the file My import: Expected: My number format: I can't see where i'm going wrong