I have a sample where there are loan dates. For each loan date, the nominal interest will be calculated from the first non-blank 'Date of Loan' entry to the last non-blank 'Date of Loan.' The total in…
Is anyone facing the problem? It worked all right till last week, but I fund it went wrong yesterday. For example, If Importing from Module A to Module B, and both of them applies to Dimension X, whic…
Hello everyone, I would like to know if it is possible to top-up the value of the current period to a specific future period. For example, in my Forecast dimension, I have a value of 1,500 for the Nov…
Anyone knows how to create a table including both Text and Number format columns like below? What i know is that, a line item can set to one format only, like set to Number or Text or other type. ..
My module contains 5 dimensions, and I am replacing one of the list subset by another list subset of the same list, I have tested it using ALM, but I would like to understand how anaplan ensures even …
Looking to return a boolean result from one module into another. Is there a specific formula or approach I need to take for this? I'd looked to just link straight to the line item in the module, howev…
Hi Community. TEXTLIST does not work in Polaris. Planual rule is to avoid using it, however, there are times when the functionality is needed. Has anyone got an alternative or workaround to achieve si…
I have three modules with different dimensions: Product Details: Dimension: 'Product' Line Item: 'Dispatched Qty' Formula I used is : 'Order Import Data'. Dispatched Qty [LOOKUP: 'Order Import Data'. …
I have access rights set for a user on customer list and on product list. Because they are both under hierarchies, once I set their visibility in the lowest level list of the hierarchy, the user can't…
There are some columns, like 'ReportingPeriod' and "Curr_Q" should be Number type while "Comments" field should be Text type. In this case, any suggestion how to set the line item format? For example,…
Hi everyone, I’m working on a fairly large Anaplan model that’s starting to experience some performance issues, particularly when running complex calculations and data imports. I’ve already tried redu…
Hi all, Is it possible to return a value from an item on the same line item? For example, picture this as my module: I want to be able to calculate a delta between S1 and S2 or S3 and S1, like this: H…
Hi, I have a list of invoices with an approver selected from the user list for each line item, what I want to do is check if the 'current user' is the same as the 'approver' and if so then allow them …
Hello Community, I need a filter in my sys module which should show only current year (this should be FY24). I also need YTD and YTG for this year, i.e current year. I also need a filter for next year…
Looking to create a module that provides a summary of a fairly detailed data set that has multiple dimensions, with having originally built this by adding the relevant dimensions to the module and the…
Hi! I am new with Anaplan and still learning the functions. May I ask how can I make a summary from a module with time dimension to a module without dimension? Here in the 1st picture is the by field …
