-
10.2.1 Add non employee expenses module
Hi Community ! 😀 I'm learning the training and I completed everything but the formula is what holding me back for the past 30 minutes.. So below is what I have : & from the training I am suppose to have ... Thanks in Advance for your patience ! @Akhtar.shahbaz
-
10.2.2 Import data into Non employee expenses module
Hi community ! Please bear with me as i have a learning disability. I keep receiving this error message ... I would greatly appreciate the assistance. Thanks in advance ! @Sowjanya @jagadishdash
-
Adding a common line item associated with a single list item
Hello all, Can you please advice how to add "line item associated with a single list items"? In the attached screen shot, •MU approved/agreed and •GS approved are list items and I have created a nested dimension in module, such that the line item is common for these list items. Now I need to add, the columns highlighted in…
-
2.3.10 Activity: Create Demand Forecast- Need Help
I'm not getting any values for my 3 line items after the baseline forecast. I cannot figure out why this is happening. I see growth percentages in my source modules, but they are not being carried over in my formula for my "DEM03 Demand Forecast Module".
-
Create DEM04 Demand Export Module
Hello, please help me define the summary methods of Demand Export Module to match my results with the correct answer from the course. here si my results The correct result is attached
-
Help with formula using IF THEN ELSE statement with Versions
Hi, I'm trying to create a formula where the End User Input will flow to both the Forecast and Budget Version of my model. The formula I'm trying to use is below. I can get the End User Input to show in my Forecast Version, but not my Budget Version. Thank you
-
8.8.2 Activity Add Formulas to Country Margin Report
Hi Community ! 😊 So Im completing the training and Im suppose to have the same page as my screenshot below : But Mines Turned out like this : Some help would be appreciated Thank you in Advance ! @Akhtar.shahbaz Im not sure if I should change it back to sum But i dont think so .
-
DEM 03 Baseline forecast formulas
Hi, I am trying to write formulas for this activity: Here is what I am doing: But the results are nor correct, How should I change the formulas and/or summary methods? Thanks
-
Export action not working properly
I am not getting the export as i selected in saved and drop down
-
Export action not working..
HI All, I have a module there i have saved view for export. when i exporting in module its showing correct data. when i create the action button and run and see the results its diffrerent . please expain the issue.how to rectify it.
-
Put a condition in a lookup
Input: ABCDEFranceGermanySpainPortugalSweden Calculate : BCDEOrigin countryFrance (A)Germany (B)Spain (C)Portugal (D)Actual CountryGermany (B)Spain (C)Portugal (D)Sweden Hello, I would like to know if you can help me with the formula for "Origin Country". It is supposed to send me the information from the previous step to…
-
Boolean Selection
Hi, Is there a way where I can manipulate the boolean checked by the user and automatically selects as well the other selection? For this example, if a user selects Forecast-Aug, it will deselect the highlighted items for Plan, Actual CY and Actual PY as well. We don't want users to do multiple selection just to cover the…
-
Lesson 9.2.5
Hi all, I am trying to input the formula in unit price % in rev05. I am getting the error "Dimension of mapping used for lookup doesn't match any dimension of the result". However, when I input the formula in unit cost % in rev05 it works just fine. I have went back to look at SYS04 and SYS06 formats/formulas and haven't…
-
issue in populating data
Hi Members , I am still facing an issue where in I have to populate FY WEEK 20 forecast with the Actual volumes of FY WEEK 19 ( ALL weeks ) I have used the below mentioned formulae IF 'SYS01 Time Settings By Week'.Current Period? THEN 'DAT03 Historic Volumes'.Volumes ELSE 0 Also used IF 'SYS01 Time Settings By…
-
Further help, with what should be a simple lookup
Hi, I have a ranking module as below This shows the top customers and some data changes ranked, also there is an image for each customer Now I have a module where I need to store the top 5 customers images to feed a business report A simple lookup in Excel, looking up 1 ,2,3,4,5 etc but for the life of me i can't figure…
-
Fetching Start Month and End Month for a given Quarter
Hi all, I'm trying to fetch Start Month of a Quarter input by the User. I created a line item for input by the user formatted as Time Period Quarter and another Line item formatted as Month. I tried multiple ways and looking for help to fetch Start Month (say for selection of Q1 FY20 - looking to fetch JAN 20 similarly for…
-
3.2.11.1 Create Planning Period Filters
Confused on which Line Item I'm building a formula for, I'm assuming both. Also this is the formula I used to so that the weeks in that month are selected as well when you select the month are as follows. Please advise. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter), Kind of confused why would not want…
-
Rank using Unique Item
Hi, I have a module which shows change in volumes by Customer - Product (over 5000 lines) I then rank these changes largest to smallest, and have a view of that. Customer ProductLast MonthCurrent MonthChangeRankCustomer A - Product 1340,480311,576-28,9051Customer A - Product 270,32646,326-24,0002Customer D - Product…
-
Level 2 - Sprint 3 - 3.3.5.2
Let me know, if what I did is right or not Create a Filter You will need to create two Boolean-formatted line items in the SYS01 Time Settings by Week systems module: * Line Item Name: First Week of Timescale? * Use this Boolean-formatted line item to select the first week of the timescale. * End users can manually select…
-
Level 2 - Sprint 3 - 3.3.5.2
Can I get help regarding this? This line item needs to display the value from the Beginning Inventory line item in DAT01 Beginning Inventory module for the first week of the year and the Ending Inventory from the previous week. The syntax of the formula should be written: If it is not the first week of the year, then use…
-
Weekly subtotals for model with calendar type M/Q/Y
Hi, colleagues! Do you know any elegant solution for entering weekly subtotals or week ID's into module of model with calendar type month/quarter/year? Cause I faced such issue: FP&A team wants a module for calculating daily sales plan - that's ok, but another step of the process is review of that plan by BU owners who…
-
NPV Function cannot get what has been provided in the technical document
Hi all, I tried to replicate the example in the Anapedia link However, I cannot get the same result as in the example as below. My module as below, my result as highlighted. Even the same cash flow data, same date column, and same formula with hardcoded discount rate. What do I miss? any idea? Thanks.
-
Why does the formula change when we change the Time Range from CY and PY to Last 5 yrs?
Why does the formula change when we change the Time Range from CY and PY to Last 5 yrs?
-
Community perspective: RANK and row counts – Management Reporting with multiple lists
A common request within any planning project is to create well-formatted, standard reports for the business to consume. However, these aren’t always as simple to create as first thought. The Management Reporting capabilities within Anaplan produce great looking outputs. However, they require a fixed number of rows for each…
-
Level 2 3.3.6 Confirmed Purchase Order Receipt shows no value???
I can't get the value or in others words add the numbers in the Suggested order amount of the month. The line item always shows 0 no matter how hard I try. You can see my formula on the formula bar. Where do you think I have done wrong?
-
Boolean value from a Time Dimensioned to non-time dimensioned module
Hi Team I want to pull a Boolean value from a time dimensioned module to a non time dimensioned module. Source module looks something like Could you please suggest? Thanks
-
Search if a list member exists in a text line item
Hello! I got a Invoices Data Load Module that gets its data from a numbered list "Invoices". The line items (invoice number, client, comment, amount, date etc) are the "Invoices" list properties. We started selling a new product last month, but our ERP doesn't fill the "client" field in the invoice when it has that product…
-
L3 TAR01 Module and it's check Module
Having trouble seeing why my check is not coming through for my TAR01 module. Attached are screenshots. Thank you
-
RANKCUMULATE function not working with a negative number
I have a RANKCUMULATE function that is working fine but when a negative number is referenced it ignores it rather than subtracting it from the running total. I am hoping someone has run into this before and has a solution for me.
-
Uniques Identifier as code for a Numbered List
Can i Use Numbered list Unique identifier as a Part of code for Numbered List?, How long can a Unique Identifier can go? I have a numbered list Named 'Activity List' under a Customer List as its parent and I am Planning to use Unique identifer as a code for that List as Name(Item(Activity…