About nathan_rudman

Hi,   this would be clearer if you were specifying which axies should have what. In any case it sounds like you need to have a module with the standard time as years and an additional list which recreates weeks (or the contrary) onto which you'll map your data. ... View more

Hi,   you need to create  "Products: Existing" and "Products: New" subsets within your product list. Then you can run a process from your model where selected line item in "Existing Products" will be added to the subset existing and removed from new. Then your second drop down can be formatted as the new subset. ... View more

Hi,   Glen's right, summary level aren't editable. To make sure only summary levels are shown, you'll have to filter out the low level elements and remove the right to filtering on the dashboard.   ... View more

Hi,   The new idea exchange is here: https://community.anaplan.com/t5/Idea-Exchange/idb-p/AnaplanIdeas ... View more

in your mod filter, do you have any other list that has a link to "my list " ? is yes you can use it but otherwise no.   This is a common case I would say and  often the solution in that situation the user has to "reselect" the element of my list they want to import (or a line item list formatted drop down but that's still a second selection). The modeler cannot access the "curent selection", neither can we access "current user" (only in the filtering) ... View more

that formula is ITEM() ;) so you can do IF ITEM(your list ) = what you want then DO else dont ... View more

Hi, there is or was a reason for that. Creating a ticket to support to complain is usually the most efficient way to get an RFE, especially if you are a customer ;) ... View more

Hi,   you should try and apply the filter to the module that contains the links as well ... View more

Hi,   that syncrhonized list must be a dimension of the source view as a page. Then you can do a filter: if item(list) = line item with that list then true else false ... View more

Unfortunately no. However you can massively change their role to no access. There's an import button on top of the user page: you can import from a module or a CSV file ... View more

Hi,   Have you tested this ? It does not work. The user list isn't available when do the action "delete from list using selection". ... View more

Hi,   you are correct this is the classic SUM usage. You probably did a slight mistake. here's how it should be: Your "Data" source module should have two line items: Value and Category and a "transaction" dimension (1,2,3,4, etc) to make the rows. it seems you have this already. Now in your target module you can have a line item called "SUM" and the category list as a dimension. The formula of this line item should be: Data.Value[SUM:Data.category] This will give you the sum of the category you select   This is essentially what you have done so just be careful to what you write as the SUM parameter: it must be a line item in a source module, not a list name, formatted as the dimension you want to SUM on in your target module. ... View more

Hi,   this is such a great question to understand dimensionality and summary in Anaplan !   I did an example, here's the "database": Note that you need to have summary levels in your dimensions   Then the result: and how this is achieved:   LOOKUPs are fully dynamic and they use the user input to find the value value at the crossing of the dimensions SELECTs are searching for a fixed value ented in the formulas, here the sumary level of the required dimension   I believe this should help you understand. Feel free to ask questions ... View more

so you concatenated all calcs within one module and hide/show them depending a selector, probably using a line item subset ?   classical I would say, don't worry about it beeing too complex ... View more

Hi, you can set the 0 the values that are outside the period you want.   let's say you have a line item called "cash flow" with all the cash flows for all periods. Create a second line item called "Specific Period Cash Flow" and a third one "Valid Period" (as a boolean). The formula of "Specific Period Cash Flow" should be: IF Valid Period then cash flow else 0   The only other way to play with Time and IRR is to use the IRR date settings (cash flow, date, dimension) but for that you need to have your cash flows as "transactions" ... View more

You cannot hide and show modules. But I guess you can have dashboards for each situation and use a button with context to open the right dashboard. ... View more

Paul's right. If you maintain the users access to cost centers in a module (which you should), you can use that to have your ranking module with the user dimension and basically set to 0 CC they don't have access to.   DCA doesn't help here though. Even with DCA, calculations do happen, even if you don't see them. ... View more

There is no way to bring native version onto a list or a line item subset without doing a select. However, having a centralized module where you use line items to recreate versions (with select) and transform these line items into a line item subset isn't too much maintenance (unless you create a lot of versions of course. You can then use a formatted line item drop down displayed on a dashboard to allow your users to choose what they want to see.   You have examples of various ways to do a dynamic variance analysis in this app: https://community.anaplan.com/t5/Finance/Planning-Budgeting-and-Forecasting-for-Saas/ba-p/28006 ... View more

Hi,   Two notes on your question: - modules are just a display thing. The property you look up on can be in the same module than your target or in another one, it doesn't matter in terms of performance - it's better to do SUM over line items rather than list properties (as Paul Said) - don't do SUM and LOOKUP within the same operation ( tosum[SUM:line item1, LOOKUP:condition]). This results in bad performance. You better do it in two line items even if it takes more space. ... View more

Hi samarapalli,   the format doesn't really matter: whatever it is, you need to check the "summary" setting of the line item you are filtering on.   For a list formatted one , if you filter is "is not blank" then you just have to select the summary type "last non blank" ... View more

Hello,   This is the sum of the gross sales amount by customer and contract name, only for the selected "Reporting Contract Stage One.Contract Map". It's comparable to a sumifs in excel     ... View more