Modeling
Modeling
Discussion List
- Let's say I have column username and a username is "JonSmith-81". What would be the formula to return just "JonSmith"?
- 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…
- Anaplan is a very smart and intelligent platform, and it educates its model builders/developers brilliantly about the mistakes or errors made. Here are some of the common errors that may occur while m…
- 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…
- That would be nice if I, as a model builder, will be able to diasable hierarchy level shift: Now I want to describe my problem. Suppose, there is a simple list with various levels in one: No parent hi…
- REQUEST: give the MB the ability to Report with a click when they hit an error like this one. It would give the error logs along with the ClientSessionID.
- Hello, I have Query related to waterfall chart in Anaplan. I have a below modules with line items mentioned. Want to create water fall chart with Actual Contribution line item acting as a total in the…
- Can anyone guide me as where have I gone wrong in this activity
- Employee Details csv is clustered and not showing up in columns.
- 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…
- When it comes to model size, few components add space quicker than versions. This is particularly true in use cases that rely heavily on scenario planning and what-if analysis. For example, a supply c…
- 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 …
- Hi, I am unable to get the result as per the screenshot with respect to Create Saved View for Export (1.6.3.3). I gave Time dimension as Half-yearly only. But still the columns FY19 & FY20 appears in …
- Hi Community, Is it possible to create a submit button either in the old user experience or new user experience in talent builder workspace (i.e Anaplan learning workspace) Thanks & Regards Badam
- Hi Community, I need to build sales planning process, where region heads should be able to submit the once they are done with the planning process and it should flow to the CEO. As a part of it I need…