-
Anaplan Way Course prior to Level 2 Model Building?
Hi, Does it help or is it necessary to complete the Anaplan Way course prior to beginning Level 2 Model Building course? Thanks in advance for answering my question. Jacob
-
Level 3 Sprint 2 Problem of Quota of Sales Reps and Assignments (User Story 3.2)
Hi, Misbah For calculating the Target of Sales Rep, I created a Line Item Sales Rep in TAR02 Account Review and created a formula of Target applying to Sales Reps Flat# in QUO07 to obtain the Target of every Sales Rep, but I received a message, but the result is not good. The Target showed Total of all Sales Reps and…
-
L1M1 Lesson 6.3.2 Format settings
Hi, At the end of this lesson in Knowledge check I did arrange the Format settings as shown in the shared image below. For this selection it is showing invalid answer. Please can someone advise what is wrong here. Thanks, Balaram D
-
Calculate First/Last Week
I want to calculate First/Last Week Like this picture. I set the "General Week" as Time Setting. I have no idea to do it.
-
Stop Summary in the middle of Hierarchy List
I have this type of List. ALLRegionCountryWorldEuropeFrance German AsiaChina Japan I want to Sum Lineitem by only Region not All, Like this Table. ListLineitem(None)Lineitem(Sum)IdealWorld 40Europe 22France111German111Asia 22China111Japan111 By calculating this table, I can filter Country List by Ideal Lineitem. How can I…
-
Percent calculation
Hi, I'm trying to calculate the following: if field a< 20% of field b then 1 else 0 How do I approach this? Please help. Thanks
-
Line Item View Selection based on List dropdown
Hi, I have to show only 1 relevant line item on the Dashboard based on the page selection. I have showed in the Test screenshot below. Like in above module if I want to show only Line item 1 if I select List Item 1 from the above dropdown and if I select List Item 2 from above then I can see Line Item 2 when I published…
-
2.3.9.1
I do not understand why there is no source object, due to this reason I am not able run the process...
-
Formula defaulting to editable in new model experience
I'm getting used to the new model experience, and overall it's a good step forward. However, I have one major frustration, which is that the formula goes straight into edit mode when I expand it out. In most occasions, when I click the 'expand' arrows on the formula bar, it is just so that I can read the formula in full,…
-
Module data transfer from time scale to different time range
Hello Everyone, I have two modules as mentioned below.I need to get data from module1 Jan20 to module2 Jan21 and same follows for other months. Module1 Time Scale -FY20(jan to Dem) Line item - Data Module2 Time Range -FY21(jan to dec) line item-data1 Can someone help me with this. Thanks Tejaswini
-
line item total in another column
Hello guys, pretty sure the solution must be simple but i cannot find it. I am trying to use the total of a line item in another formula. what i have looks like the screenshot Thanks in advance 🙂
-
Bulk Copy from a dashboard
How do I give dashboard users the ability to run a bulk copy from a button on the dashboard? Specifcally I have a list which contains "versions" I want to make the copy of Current Month to Prior Month an end user action from a dashboard.
-
4.6.5 Sale Planning Model: DAT02 module
Hello All, Please note, while working on 4.6.5 Sale Planning Model: DAT02 module, below are the steps i have completed- 1. Created A2 Accounts. Product# list and updated it with concatenated codes 2. Created new Model DAT03 PY Revenue from Data Hub for inputting data from Data Hub 3. Created DAT02 PY Revenue to CY as per…
-
Movingsum
Hi, For your assistance please. I am trying to aggregate specific invoices and tried using the movingsum but on the last invoice cut off 4 which the number of days are variable. How can I count and use the movingsum? or is there another formula I can use? Example : August 2021 Invoice cut off 1 - starting 1st of the month…
-
Level 1 Model Building Certification Exam : Unable to format Roles as List in SYS08
I am having an issue with the Role list. When I try to format the Role line item in SYS08 it gives me this error: Format of mapping used for lookup doesn't match any dimension of the source. I've attached a screenshot of the blueprint. I've had no luck fixing this issue and I'm going on hour 4 of trying to finish this…
-
Fake Week and Sum with Month
Hi, want to SUM value with Month. I set the time setting as "Week General". It has no month aggregation, so I made the Month List. And I calculated month value as a described below. <Solution1> Formula: TimeSum(Weekvalue, start, end) +value(adj)[Lookup:start-1] - value(adj)[Lookup:end] week(start/end) start end weekw6/28…
-
TIMESUM syntax error
Hi everyone ! I am currently doing the Level 2 Model Builder, Sprint 1, and I am stuck at step 1.5.7 Basically, I need to feed a boolean Line Item called "Has Data?", which is on the SKU ; Account dimensions from a numeric Line Item called Volumes, which is on SKU ; Account ; FY19 dimension. Therefore, I need to aggregate…
-
SUM with Week general value.
We're using "Week General" as Time Setting. Week General has day and week value, but does not have Month Value. So I made Month List(Jun21-Dec21), and I want to aggregate the value from day to month. I used "Timesum" function, and could aggregate it week to month. Formula:Timesum(Lineitem, Startweek, Endweek) But I could…
-
Import Data
Hello Dear all, How to set the data as a Custom Mapping?
-
Training questions
Hello all I am new to this and want to start learning level 1 model builder. How many classes are required for it and how much is the cost? On instructor led training, it shows class registration with fees of $1750, is that a fee for one class? Please guide. Thank you .
-
Source to Target Mapping for Imports into a Module
Please select the column that contains the data values. What is error do mean, and how to fix it?
-
Version limitations
Hi All, Version as list has limitation ,,,that we can not use Switchover. Why we can not add this in scenarios? Also Why can we not use Switchover in line item to fetch a formula and scope to use it?
-
Level 1 Activity 13.6.5
Hi, In activity 13.6.5 of the L1 MB course I am supposed to use Custom Views and use Time to filter such forecast is shown by months and FY totals. In the model view the FY totals show at the end of the year. However, in the Custom Views it is at the beginning. Please see attached screenshot. How do I get the year totals…
-
Multiple Items Identified as First Occurrence
We have a module dimensioned by Time and Item ID. One of the Line-Items in the module is Item Category. We need to identify the unique categories. ISFIRSTOCCURRENCE seemed to be the answer but it is identifying each category as being the first occurrence multiple times, once for each period. How can we identify the unique…
-
Level 3 Model Building Sprint 3 User Story 1.2
Hello, I am sure, this is very basic doubt, but i am not able to solve it. In 3.2 section, where we have already imported Baseline Financial Forecast from Excel sheet, now we are supposed to enter Stretch Goal/ Percentage increase for country's. My problem is, i am not sure how to enter time in one go. When i am going on…
-
Time summary setting for a line item with "Formula" summary setting.
Hi All, I am currently working on a requirement to cumulate the value of a line item. For this line item I have opted for the Summary method - "Formula" but I dont want the overall total sum for this column; I tried to change the "Time summary" for this line item , but it is throwing me error - Invalid combination of…
-
L2 Sprint 1: 1.5.3.1 Create Filter and Saved View for DAT01 Module - Issues with Filters
Hi, Im having some issues with activity 1.5.31 creating the filter for DAT01 Module, when I set the filter in place to show only values different than 0, i cant find the button to confirm the transaction and apply the filter. Can anybody help? Below snapshot. Thanks
-
Help Replicating Excel Formula
Hi, We are trying to replicate the following set up and formulas from the below Excel snap shot into a Module. Currently the Module is set up where there are two list in the rows. In the Excel the formula for the Rollup is based on a calculation and we want to replicate that in Anaplan, but in Anaplan the Parent item…
-
Help with Profile formula adding up few line items
Hi all, I keep having the same error, when I tried to add up few line items with PROFILE calculation in it. I have created a module to calculate items of the balance sheet and multiplying them but % over a period of time. When I try to add all the items to get the total, I have an formula error as per the picture attached.…
-
Ranking and List
Anaplanners, I have a module with a list "project" each project is ranked with a line item called "Rank" which uses rank functionality. Is there a way i can create a page selector/list which filter the projects based on rank, for example, i create a listitem called "1-5", the module should revert projects ranked in those…