Modeling

How to add prior year data value
Hi, I have a line item Headcount and my current year is FY17. For FY18 I need headcount value to be prior year headcount and FY19 to be FY18+FY17 headcount value. Can I please get some guidance. Regards Madhu
History not getting captured for Cell
Hi, I have entered 128 value in one of the cell in module. However,after few days i could see value has been changed to 125. Upon checking in the history,last value change is showing as 128 and nowhere 125 value change has been captured in history. Please help on this.
Totals at rolled up level
Hi, We have applied some filters on the basis of which we want the data to be published on the dashboards. The data is correctly being picked up as stated in the filters, however at the total level(level at which data is getting rolled up) the totals are coming incorrect , it picks totals of the entire e.g. region/category…
How to take summary values into calculations?
Hi i'm trying to get last fiscal year actual values but not able to take it to next year budgeting please help.Below i'm putting the logic & where i'm struggling. Time apr-18 may-18 aug18.......FY18-19 Apr-19 may-19 jun-19 jul-19 Fy19-20 Actual 1000 2000 1000 4000 Budget 4000/12 4000/12 4000/12 4000/12 Here i'm not able to…
102 Certification Project - Corporate Profit
Hello, New to the community and stuck on Company Profit as none of my output match for answers in the certification quiz. My COGS doesn't feel right so I attached my Partner and Direct revenue Blue Prints as well. Not sure how to proceed as I've racked my brain on this. Thanks
How to Convert Number into Weekly format?
Hey Anaplanners, Is there any way that a particular number or text can be converted into Weekly format? For example P1 2018 needs to be converted into Week 1 2018 in a Time Period Formatted Line item. I know for the fact that we can create Date from number but there is nothing as such for Time periods esp weeks. Let me…
If Formula Error Message
I need help with a formula. In a module to calculate 401K match for employees, I have the below. There are 2 types of TM's - "Regular" and "PRN". The below works perfectly for "Regular" TM's. However, I want to add an IF statement to the TM Total Salary calculation that basically says IF TM Type = 'Regular' THEN use…
Can we create alias names in anaplan?
Can we create alias name for time,versions dimensions in Anaplan?
How to Count Text Value based on the Input.
Hi All, I'm fairly new to Anaplan. I want to count a list item (Model State in Text format) to be able to output its count to my dashboard. The three current inputs are Maintenance, Production, and Unlocked. I want to be able to show on my dashboard how many models are per state. I tried fiddling with the IF function for…
Anaplan and SAP BO to Tableau connection
we are using Anaplan to view my data in tables. Is it possible to get the data from Anaplan dashboards and visualize them in Tableau? Same applies for SAP BO reports. Thanks in advance Saanvi S
How to: Annual Repeating Value shown with Monthly phasing (rents etc)
I needed to take an Annual contract value, and model the payments by month at different frequencies and came up with a solution I thought others might find useful. Here's the finished dashboard. For each Site, you select a Payment Schedule. Input the Annual Contract Value and tick which months to allocate the payment to.…
How to add cell values for previous 8 months data only
I have an line item 'Amount' with data values. second line item(months applicable) which is boolean checked for only 8 previous month of current month. I want to add the values of these Boolean checked months only to be summed. Can I please get some guidance here please? Regards Asha
Open a Module in "Line Items" tab by selecting a line item (not just a module)
When I can't remember where I saw a particular line item, I go to Settings ---> Modules ---> Line Items and search for it. When I find it, it would be very natural to just click "Open" in the header. However Anaplan only allows this open button to work if you have the MODULE name it belongs to selected. So I have to scroll…
ABS formula
Hi, anyone who can help on formula "ABS"? I need to get the absolute value of the line item, but Anaplan seems to round off the item. Any notes on this? Thank you. Below is the screenshot for sample:
IMPORT ERROR (MODEL TO MODEL)
Hi all, Anyone encountered this error? We cannot import from one model to another because this error occurs every time. Kindly see below:
Process builder in anaplan
Hi, Can anyone give brief about Process builder and its task in anaplan. Thanks, Keerthi Malathkar
How to get the previous period of current period
Hi, Can I please get some reference how to get previous period of current period. PERIOD(CURRENTPERIODSTART()) gives me the current period I,e Jul 17 but I need Jun 17. Previous(period(currentperiodstart()) which is not working.
How to add cell values for previous 8 months data only
I have an line item 'Amount' with data values. second line item(months applicable) which is boolean checked for only 8 previous month of current month. I want to add the values of these Boolean checked months only to be summed. Can I please get some guidance here please? Regards Asha
Can we create alias names in anaplan?
Can we create alias name for time,versions dimensions in Anaplan?
Hierarchy change in planning years
How to save the data of the previous years when we want to change the list items hierarchy in planning years? Other than creating a copy of the model, is there any solution??
Formula for the Hierarchy
Formula for the Hierarchy
Ability to Merge and / or Replace a dashboard with another dashboard
I would like to be able to replace a dashboard with another dashboard and have Anaplan automatically make all the changes needed to make the replacement be and act as though it was the original the whole time i.e. do all the renaming, change all actions, filters, permission etc. WHY When trying to prevent new features on…
Poisson function
My customer needs to calculate the POISSON cumulative results to find out the lambda value that goes above a probability treshold. In a maintenance use case, this is useful for him to statistically determine given a target service level and the past average of incidents how many incidents should occur in the future, and…
Customize Model Filters
Consider allowing customers to customize the filter categories. App, Geography, Planning Cycle, Environment, and Business Function do not fit our use cases or model categories.
Default Home Page to list view
We would like the ability to default the tiles screen to the list view for all of our users. This view is a lot more user-friendly than the tile view, we have had an abundance of requests for model access when the users do not realize that they just need to scroll to the right to see additional pages of tiles.
Custom Format for Lists
Currently all list items default to text. It would be helpful to add them as dates, numbers, etc.
NULL Number Format
Null option for number format. Currently when a number in undefined, it will populate the module as a 0 instead of a blank. A work around is required to convert all of the numbers into text, and then make undefined numbers "N/A". The ROUND(TEXT()) function also causes a large number of unnecessary decimals.
Default Dropdown Selection
Ability to set a default selection in a list dropdown (similar to how you can in tables and graphs). Allow different default selections on different dashboards.
Dynamic synchronization based on list-formatted line item
Dynamically synchronize published tables based on a list-formatted line item page selector. This would save space since we wouldn't have to dimensionalize the model but could use a list-formatted line item.
Keep Dashboard Tables Anchored
When making inputs to large tables, the dashboard will scroll back to the top after making an entry. The ability to have the dashboard stay anchored while entering information would save time for users. We are having to use the maximize feature for each table to input data.

Modeling

Discussion List