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 conditi…
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…
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 Product…
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…
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 c…
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 acce…
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 …
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 f…
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…
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 …
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 PO…
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 he…
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 y…
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…
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 …
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 f…
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 …
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, LOOK…
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…
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 U…
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…
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 …
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 a…
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 …
I am having an issue that I'm not sure is able to be solved, but wanted to ask the community to see. I have a hierarchy as follows: Top Level = Total Company BU L1 parent = Total Company BU L2 parent …
