-
Dependent dropdown
I want to create dependant dropdown for Accounts (Dependent on Country and Segment) to complete the user story 2.5 Level 3. However I am able to select only one either country or segment. How can I create account dependency on both? Thanks -Pooja
-
L2S3 INV01 Shipping Costs
Hi community members, can someone please take a look at my formula for 3 3 5 6 Update Inventory Ordering to Calculate Shipping Costs - Shipping costs line item Here's the formula hint provided in the course: Formula Hints: Shipping Costs: * In the TRA01 Shipping Metrics by Week module, the Shipping Costs are priced per…
-
Function to return the number of leaf items in a standard or numbered list.
I think it would be very useful to have a function to return the number of leaf items present in a standard or numbered list. Example: QUANTITY(x) Where 'x' is the name of the list, also selectable from 'General Lists'. Reasoning: This would serve as a cleaner way to get the number of items in a list, instead of doing…
-
Level 1 Activity 6
How close am i here??? The formula for 'REP04 Employee Expense Summary'.Salary is invalid: Salary = IF Employeed? LOOKUP :'SYS08 Employee Details'.Current Salary[LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: 'SYS08 Employee Details'.Region] ELSE 0
-
Error when Exporting Text formatted Number: Missing Leading zero
I have a text formatted line item called Company Code = "0505" When I export the module, I noticed that the Company Code becomes 505 instead of 0505. Why was the leading zero removed when I exported it? To solve it I created another line item thats number formatted and called it New Company code = VALUE(Company Code) The…
-
User wants to change the employee's department.
Hi, There are lists (Department and Employee where the Department is the parent of Employee). I want to make a UX page where the user can select the employee and change his department, therefore details of the employee such as salary will reflect in the new department. Please let me know how I can achieve this. Thanks in…
-
3.3.5.3 Check Your Work - I don´t understand were I´m wrong.
I have done all formulas and checked my work against the course examples and everything was good until I review the Nutzo Bar_En selecting the Submit Purchase Order Request? I get the following: The example given in the course says that the confirmed Purchase Order Receipt for Jan20 should be 8,194 but I get 8,396 (same as…
-
issue with inventory modelling
i hope this message finds you well i would really like to have your insight and troubleshooting skills on the issue i am having with the inventory ordering module the following are the line items and have related screenshots with respect to the problem. formula of the line items: IF NOT 'SYS01 Time Settings By Week'.'1st…
-
Target module with less number of lists
In my situation here, I have a source module that has two dimensions - EMP and Geo and Time and line item called MAP which is list formatted (GEO). Target dimension has one dimension EMP and Time and line item that is list formatted (GEO). I want to bring in the Geo from source to target in this case. Since the target has…
-
Add 'Does Not Contain' as condition when performing a filter on a text formatted line item
Many of our users would find it helpful if when filtering on text formatted line items, there was the option to use 'Does Not Contain'. There is a 'Contains' condition, which has proved helpful, however a 'Does Not Contain' would also provide a lot of value.
-
L1 Question 6, getting 0s
Hello, I have entered the following formula and I'm getting zeros on the Employee Expense Summary. Any ideas?
-
Sprint 2: DEM02 Module Formula
Hey, When creating the DEM02 Volume Growth Rates by Week module, the activity wants you to "Write a formula to pull Volume Growth Rates value (in months) from DEM01 module and convert to weekly value". However, under the Anapedia resource it links to explicitly states that the functions listed can aggregate from Weeks to…
-
How to add a button that creates a new line item in the GL that has a hierarchal structure
The current button we have in place has us add in a new SUB-GL/ vendor item to a numbered list. That numbered list uses an OpEx subset that layers in each new vendor into its respective opex area such as adding "Anaplan 2.1" under Software subscriptions in the GL. The problem im running into is that this current structure…
-
How OFFSET operates? Please explain with examples.
-
Performance affect of "SELECT:" and "LOOKUP:" used together
Hi community! I couldn't find any information on whether it's recommended to split SELECT and LOOKUP for better performance. This thread helped me to understand that SELECT works in a similar way as LOOKUP (thanks to @DavidSmith for insight). So does it mean that SELECT and LOOKUP can be used together, unlike SELECT and…
-
I want a formula for Boolean line item as true for below requirement. How to do that?
.
-
Does Anaplan allow different formula for each versions?
Hi! For example I have 4 versions namely: Actual, Budget, Forecast 1 and Forecast 2. Does Anaplan allow different formula for each version I have in my module? Say, Actual version will have a different and unique formula with Budget, etc for the same modul. Thanks for any help!
-
HiI want to use quarterly sum in another module which is in months. How to do that?
-
Introducing the Optimizer Toolbox
What is the Optimizer Toolbox? The Optimizer Toolbox is a Model Builder’s reference guide that details common linear program constructions for themes such as allocation, scheduling, and time-phasing. Each theme is dissected in a sequence of modules that progress from simple to complex. For example, the “drawer” on…
-
How to pull previous year end balances into a monthly calc
Hi So I am having a bit of an issue I need to do a calculation monthly, but I need to refer back to the previous year end balances as my start point for all months. I tried doing it with offset, why I take a starting balance for that month, and then offset everything back to December to lookup the amount needed in my calc,…
-
Apps > Report: Add Variance between rows
The new feature in Apps > Report to add variance between columns (as shows in the screenshot) is fantastic. It would be very useful to have the same feature to calculate variances between rows, but this is currently unavailable. It would be greatly appreciated if this feature could please be added as soon as possible so we…
-
I want Booleans as true as per below requirement
-
How to convert text to date
Hi , I have a text formatted line item which is a date .I want to convert it to Date format . I tried to break it into three Year ,Month and day using Value(RIGHT(Line item,4)) Value(Mid(Line item,4,2)) Value(LEFT(line Item,2)) It works for 12/10/2012 but what about 2/3/2012 ?? Note -- Can't change source text to date…
-
Boolean with summary : "all", true for parent with no child?
Why is a Boolean line item with summary set to ALL true for Parent even when there are no child items? I noticed that a boolean line item was true for a parent in the hierarchy automatically if summary was set to ALL even if it had no children. Why is this so? I thought if summary is set to ALL the parent would be true if…
-
OEG Best Practice: Formulas and their effects on model performance
Details of known issues Challenge Recommendations Performance issues with long nested formulas Need to have a long formula on time as a result of nested intermediate calculations. If the model size does not prevent from adding extra line items, it's a better practice to create multiple intermediate line items and reduce…
-
Level 2 Sprint 2 2.3.10
Hi, as a result for the first question (2.3.10) I have the answer 71.34 but it should be 73.48. I don't seem to understand where I made a mistake. Could anyone help me out please? - DEM01 screenshot 1 (DEM01) - DEM02 screenshot 2 (DEM02) - DAT03 screenshot 3 (DAT03) - Formula: IF 'SYS01 Time Settings By Week'.'1st Forecast…
-
3.3.12 Activity: Create Product Replenishment UX Page - Conditional Formatting
Hi, For this section of Activity 3.3.12 regarding conditional formatting, I have not been able to find the rule to reflect the condition below: * Add conditional formatting to display Ending Inventory as red when the value is less than the Safety Stock Target value. See below the options I see for conditional formatting,…
-
Level 2 Conclusion INV05 Shipping Export
@Misbah Shipping Costs = 'INV01 Inventory Ordering'.Final Shipping Costs[SUM: 'SYS08 SKU Details'.Distribution Center] This formula for the shipping costs line item is giving me '0' as values. Is it because the formulae I have entered is wrong?
-
Calcuation of subsets as my allocation basis
Hi guys, how can i get the totals of my subsets in my formula so the totals of my denominator will only be the totals of the subsets? Thanks in advance.
-
Update Historic Volumes for Baseline Forecast
Hi Im trying to build the volumes for baseline forecast and below is my formula resulting in the following error IF 'SYS01 Time Settings By Week'.'1st Forecast Year?' THEN 'Offset Volumes for 1st Forecast Year' ELSE IF 'SYS01 Time Settings By Week'.'2nd Forecast Year?' THEN Offset('Offset Volumes for 1st Forecast…