-
2.4.7.1 Conditional formatting
Hello. I'm stuck on the conditional formatting for the Final Forecast line. I noticed that my formula for the line item forecast cf only results in 0 no 1's, I'm not sure how to fix this as my conditional formatting will not show blue if I don't have any 1's as a result. Formula - IF Initial Demand Forecast = Final…
-
Level 2 Sprint 3 - 3.3.5.2 Inventory Ordering Module Formulas
Can anyone please help me with the formulas for the line items attached in the screenshot ?
-
Does the "Anaplan Formulas & Function" app still works?
Hello, Does the "Anaplan Formulas & Function" app still works? When clicking on "Download this app" I'm directed to a page "HTTP Status 400 - bad request". Thanks, Evrard
-
Additional functionality of multiple non-linear regression analysis
A description of the enhancement required: To move beyond the statistical forecasting model from Anaplan, additional functionality of multiple non-linear regression analysis and ability to derive data set screening with statistical significance p-values, r-squared coefficients, and more advanced modeling as is being…
-
How do I get the characters before a specific character?
Let's say I have column username and a username is "JonSmith-81". What would be the formula to return just "JonSmith"?
-
3.3.5 Shipping Time
I cannot seem to get this formula correct for shipping time in INV01: time in weeks for the default shipping method for each SKU. TRA01 contains shipping time in weeks, shipping method, and P2 Products. SYS07 contains default shipping method and distribution center. SYS08 contains distribution center, SKU by code, and P2…
-
Formula Help
Hi Community , Can anyone help me describe how to use RANKCUMULATE function with an example , I understand the function syntax and all but I want to understand a use case of where this function can be used. Thank you!
-
3.3.6 Changing OFFSET to LAG
Hi all, Having some issues changing the OFFSET function to LAG. Using the following formula; LAG(PO Submitted, Final Shipping Time Weeks, 0) My Final Shipping time in weeks is 1 for the PO submitted column, the lag I am seeing is however 2; The only way I can get the LAG to show up correctly is by checking multiple…
-
Configuring Write Access Driver by Drop-down
Hello, I am trying to configure the write access driver of an item to build something as follows: If drop-down item is selected, then the write access to a column is revoked. Else, you have write access. Can a write-access driver be configured to dynamically change once a drop-down item is selected? All the examples that I…
-
3.3.5.2
Can anyone guide me as where have I gone wrong in this activity
-
Add MEDIAN Function to Anaplan
As we expand our use cases within our org, we are faced with more and more times that we need to calculate a Median within a data set (ex. Revenue, Median Deal Value, Median Salary, etc.). There is a quite elaborate workaround that is posted on the community, which has been a lifesaver, but it takes up to 13 line items to…
-
Christmas Brain Freeze or Summing from a module when you don't have time as a dimension
Hi, I have a module (SER) with simple data for a PO, value and a year period by customer In an invoice module (that does not have time as a dimension) i want to see the total value for that customer for the year. The invoice items has a Year based on its posting date. SER.Value[SUM: SER.Customer] This gives me the total,…
-
Product Summary Method
It would be useful to have the option of Product as a summary method. For example, if you have a list of % discounts that all apply to one sales order then they need to be multiplied together in order to give the total discount.
-
How to get last day of the month
Hi everyone. I would like to get last date of the month when certain data is entered. Image: I would like to get only the last day of each month that meets the conditions. Item is List format. Please tell me good solutions. Best regards.
-
Confirmed PO Delivery - OFFSET
Hello, 3.3.5.1 Create Inventory Ordering Module I'm having the hardest time understanding which line item to use in the Confirmed PO Delivery formula. The threads I've read keep referring me to the POST function, but I'm not at that point in the training yet. The following set of instructions are confusing me: * Set the…
-
8.6.4 Activity: Add Formulas to Margin Calculation Module.
Hi Community, For this activity in my model I don't have the dropdown selectors. What am I missing? This is my model: This is the lesson page: I don't have the drompdown for city or product. Please help. Thanks.
-
Need help with 1.5.7.2 Add Formula to SYS13 Line Item
Hi All, I am struck at this point. I have followed the notes carefully Add the formula for the Has Data? line item in the SYS13 Account SKU Filter module. Considerations for the formula: * How could you sum the data over all time periods? * All Periods is not an aggregation method at the model-level timescale. * The…
-
level 1, 11.3.4
Hi, In model building level 1, while doing activity 11.3.4, I a not being able to correctly put the formula. I checked spellings and everything, and all looked good, but still it says invalid, or line item not found. Kindly look at the screenshots attached and let me know.
-
Employees in 2 Departments
Hi everyone, I am trying to solve an issue we currently have. We have multiple departments within our company, and we are implementing a new department, Department X. There are multiple employees who are in departments other than Department X but will be helping, and we wanted to allocate part of their salary to that…
-
Need help in creating correct Formula to get Employee expenses by Roles and Department
I assumed, I have created a formula using LOOKUP to get correct value in Employee expenses module however the outcome is incorrect when I am answering the questions related to it. Hence I believe my formula is incorrect. Not sure if someone having expertise on this can guide me to build a correct module here. Thank You…
-
Evenly Spread Amounts
Hello- We have two modules one for planning miscellaneous revenue and other for planning for OTPS. When a user enters an amount in the FY21 column the amount is not spreading evening for the forecast period. The forecast period is 6 months. Please see the attachment. I am not sure what I need to do to fix this.
-
L1MB Activity 5
Hi Team, Looking for some guidance on L1MB Activity 5. I built the following code: IF Employed? THEN Salary * 'EMPO3 Employee Drivers By Role'.Bonus %[LOOKUP: 'SYSO8 Employee Details'.Department, LOOKUP: 'SYSO8 Employee Details'.Role] ELSE 0 But get the following error message: "Automatic sum of 'EMPO3 Employee Drivers By…
-
How to get the first year from a Boolean
hi! I want to get a year. If there is a Boolean value at the beginning throughout the year, we get the year How do i do? Please help me!
-
max date
Hi Anaplan expert, The module below has a numbered list and some line items. The formula on the Max Date field is Date[MAX: Date]. I didn't get any results. Could you please tell me how the formula to get the max date from the Date field is? Regards,
-
Logics can be used for repetitive Users
Hi I am having a module with Products list as dimension and Users(Default Users formatted), Status and Boolean(Target Line item) as line items. I need Boolean to be checked for the Products wherever Users are same and Status is Inactive. UsersStatusBooleanproduct1User AActive Product2User AInactiveTRUEproduct3User…
-
Level 1 Model Building Exam Model Building Activity 6
I need a little help figuring out why I’m getting the the message pictured when entering my formulas.
-
Get Last data in all time
Hi, I use week General as Time setting. I want to get Last day in all time. Module A Time2021/1/12021/1/22021/1/32021/1/42021/1/52021/1/62021/1/7Num1111111Offset(Num,1,0)1111110Last day 2021/1/7 I can get last day in Module A. But I couldn't get in Module B( has no time, has Product List) Module B ProductLast…
-
SUM Function and List ALL
I want to aggregate the order From Table A to B. Table A RegionProductamountax100 y10bx200 y20 Table B Regionaggregatex300y30 I input the formula as below. Aggregate = Amount [SUM:Region] But I could not calculate it. If I have RegionALL as Region's top level of item, I could calculate it. We should use Top level of item…
-
Which aggregate function is good at performance
Hi, I want to use aggregate function. I want to aggregate "Date" Lineitem from Order A&B to Aggregation Module. Date Lineitem has Date format. I use " OrderA.Date[Max:Product]" as Formula. And I can also use "Fristnonblank" and so on because Date Lineitem is common in module. Which Formula is good at performance? Each…
-
comparing list items and changing value
Hi, In a module I had a list (A1,A2,A3,A4) and a line items Value,type(list formated line item),change value if two list items has same type and status as inactive then change value for inactive list item should get active list item value EX: valueTypeStatusChange…