-
how to get a value of last week in a quarter
please help. we have scenario to get the value of a numbered field of last week in a quarter. For example we are in Q 1, we want the value of week 13 (which is last week in first quarter). do we have any functions available to get the value?
-
How do I create a reporting forecast FTE module based on a time-dimensioned actuals module?
Hi, I have a monthly report for employees actual FTE, start date and leave date. I import this into a module: * Dimensions: People, Time * Line items: FTE, Start Date, Leave Date The forecasting for future month should be: Previous total + New joiner that month - New leaver that month. So if I look on the September data my…
-
Update Historic Volumes for Baseline Forecast IN LEVEL 2
Why am i getting error while updating the formula?
-
L1MB - rep02
I'm having trouble with level 8 Rep02 I'm getting the following error: Data type mismatch: format other than LIST or DATE being referenced as a relation I hope you can see my screen print with the other modules referenced
-
Level 2 Sprint 2 2.3.10
My DAT03 works perfectly, but sometimes it shows as Zero on the Offset Volumes. I think this is because the formula being too heavy. It is funny as I think I did a work around instead of the required formula for DEM03. I am not sure if this is the right answer or not. I imported instead of a formula for FY20 for DEM03.…
-
Rank and Sort List with Child Items
We have a list within our Data Hub that needs to be sorted in a very specific order. We import this list into several spoke models on a recurring basis and in the past we've had to manually reorder the lists in every spoke model when new items are added (because new items are always added at the bottom of the list). To…
-
How to calculate within specific tenure?
Dear All, I am looking for the best solution how calculate/distribute an amount within specific tenure once it was triggered by a variable. Example: 1 million of revenue will be recognized equally over 24 months once the project is completed. The 1st month of the recognition starts on the following month once the project…
-
level 2 prepare for sprint2 activity
Not sure which saved view have to be imported from Data hub model?
-
Value from wrong version is returned
Hi, I have a problem where I get value summed by a wrong version returned. From a module without any versions, I want to pick up FTE values from budget version in another module which has versions and sum by which role the employee has. The formula looks like this: 'FTE Module'.'FTE'[SUM: 'FTE Module'.'HR-Role', SELECT:…
-
Period shown module automatically update when i update the time selector
Hello, Is there a way I can automatically change the shown period in my module when I change the time selected? See screenshot attached. I need to show the period in each line item. Thanks, Tom
-
Year to Date Cumulation
Is there a function where I can cumulate an amount but reset it to zero when January is reached in the next year (we are using a 2 year timescale)?
-
Page breaks on auto-email links "mailto:" syntax Makelink formula
Hello everyone, I created a line item and formatted it as text/email so I could create a link on a dashboard to email approvers. It pulls the approver's name (code-which is email address), puts in a subject, and writes the email which changes based on risk level, High/Med/Low. Then writes in the description of the project…
-
Level2 Sprint1 model builder user story 4
My actions tab have following 3 actions extra as compare to view shared .They have no related processess may I delete them
-
Line Item Shipping Cost INV01
Hi, I need guidance on writing the Formula for this Line Item. My formula is below. 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:Shipping Method} Thank You
-
Line Item Safety Stock Flag Count
Hi, I'm having trouble writing the formula for this line item. This is what I have so far. Please advice. 'INV01 Inventory Ordering'.Safety Stock Exception Count[LOOKUP:'SYS08 SKU Details'.Country Made] Thank you
-
Monthvalue Formula
Hi Im revisiting my formulas and find that the output is the same with either A or B : Is there a difference between the two ? I want to apply the monthly growth values to weeks. A. MONTHVALUE('Volume Growth Rates'.Growth %) - WEEKVALUE('Volume Growth Rates'.Growth %) B. MONTHVALUE('Volume Growth Rates'.Growth %) Thanks…
-
Level 2 Sprint1
Activity asks to create a view for export for module DAT04 Distribution Center Parameters.I cant understand the Hint.Why to use system module we can use filter in module and show only half years? Why help is needs from System module?
-
Line Item Format: List - Able to select any member if list hierarchy?
I am using a composite List hierarchy: L1 List (Parents) >L2 List (Parents) >>L3 List (Children only) In a module line item, I format a line item to Type = List, and List = L3 List When I choose the pick box for that line item in the module, I can choose any member of L3 List. The members of L1 List and L2 List appear in…
-
3.3.11 Activity Question
Hi, Not sure which line item I need to write the formula for. Also this is the formula I came up with. Please advice. MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter) Thank you
-
Sprint 1 Dat 03 Historic volume
Activity 1.5.8 asked to save a new view Export but in my final view (file attached"export view")All weeks sales are adding up and showing under Jan19 while it should be blank as shown below What am i doing wrong?
-
DigitalCPX 2020: Expert Advice: Formula Optimization with Mark Warren
Curious to learn more about the calculation engine and how formula impact your model’s performance? In this session, discover techniques for improving calculation performance through formula optimization. https://www.youtube.com/watch?v=ujnk0llnsZM We will focus on three key areas: * Golden Rules * Complexity * Text…
-
Store RUN LOGS and ERROR LOGS for automated actions
Hellow Experts! We need to store RUN LOGS and ERROR LOGS for automated actions (ex: IMPORT) using Anaplan Connect. We have scheduled .BAT fils to automate actions everyday (Ex: Load GL data from SAP everyday morning at 6am). Is there a standard functionality to track all the RUN LOGS and ERROR LOGS for automated action? If…
-
Need help in setting the column
Hi Need help in setting a column up in our module. We have four separate columns , Cons_Last Month, Cons_Last Quarter, Cons_Last_Half Year, Cons_Last_Year, which are the numbers of past historical consumption quantity of a particular sku. For better presentation, we want to show all these under one column header '…
-
Accidentally deleted a module formula
I deleted a formula which I don't want to write again, is there no way to undo the deletion? Control+z is greyed out.
-
Need help in fetching last quarter /last half year
Hi I am trying to use a formula to fetch the last quarter and last half year. I have a line item 'Current Quarter' in my module which has the current quarter. ex.Q3 FY20. I want to apply formula on this line item to get the last quarter and last half year values. Any help is appreciated . Thanks Regarrds Prabakaran
-
Week Calculation-Alternate way to put number of weeks in a year
Hi Everyone I am using '52' to show previous year data of same month by subtracting: 'PY Month(week)' - 52 Is there a function or alternate way to use replace '52' and not use it in formula as a number but a derived value from some function or calculation? Thanks!
-
Unwinding debtors into future period
Hi, I have a line item with the balance for each invoice which is a list at the end of the month I have another line item for the predicted timeperiod that cash is expected I want to forecast cash received based of only the current months closing position. regards
-
INV01 Line Item;Shipping Cost
Hi, I'm confused on the Line Item Formula above. Please advice. 'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'[LOOKUP:'SYS04 Product Details'.Size, LOOKUP:(Final Shipping Cost/1000)*'TRA01 Shipping Metrics by Week'.'Cost per 1000 Units'] Thank you
-
Line Item Override Amount-write?
Hi, Stuck with this formula for the above Line Item. The formats are Boolean and Number so not allowing me to use a similar formula like I did for Override Shipping-write? Please advice. IF 'INV01 Inventory Ordering'.Submit Purchase Order Request AND +'INV01 Inventory Ordering'.Override Amount THEN TRUE ELSE FALSE Thank…
-
3.3.7.2 Add DCA to INV01 Inventory Ordering
Hi, I need further clarification. Do I create the new Line Items that are listed here and then create formulas for each based on the specific purpose? I just need clarification on what I need to do here. I have attached a screen shot of what I did so far by adding the Line Items, but have not formatted yet nor written…