
Calculation Functions
Calculation Functions
Discussion List
- Hi, I have 2 line item, Submit and Approved, Both are Boolean format. Once an Item is both checked for Submit and Approved as True, I need Submit(line Item) to be read only, i.e it should not be allow…
- Hi Experts, I have 2 issues with my formula, 1. I have written a formula to line item "Territory Code as Number" = IF Active Assignment? AND LEFT(Territory Code, 1) = "G" THEN VALUE(RIGHT(Territory Co…
- I have start and end date for an event. I would like to find what the mid point time period between these dates is. Is there a formula I can use to do that?
- Hi Anaplan, It would be really helpful if it were possible to hide the 'Parent' 'Code' or any property columns on list views published on dashboards. This is to prevent any destructive inputs such as …
- Hi, I have a flat hierarchy, which is used in a module. A Boolean line item is created in same module, but I want my Boolean field to be enabled only for particular member in the dimension list and di…
- Hi, We have a list called Sales Titles which has all of our Sales Titles. The code for each sales title is a plan ID. 1:1 relationship. Some sales titles have the same exact plan components, but just …
- 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. Regar…
- Hi - struggling to get my head around this. Not sure if I'm getting the syntax wrong, or whether what I'm trying to do simply isn't possible. I want the model user to be able to make a selection in a …
- 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-1…
- 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 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,…
- 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 Un…
- 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
- 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 checke…
- 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:
- 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(currentperiodst…
- 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 checke…
- Formula for the Hierarchy
- 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 de…
- 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 …
- Ability to select multiple cells in a drill down window and see the sum on the back end, as you can on a dashboard.
- Hi all, I am trying to see if there is a way to reference the model calendar in a formula. I want to return the fiscal year that the week is in. e.g Week 1 FY19 Result would be FY19 The intention is t…
- Hi, I have created a master time dimension setting module where my current month(Boolean line item) is selected as June 18. I want all the 8 previous months value to be read by a second line item from…
- Hi, I'm trying to create a formula that has 2 different views of forecasts. My current and my previous. Current is pulling in fine. Struggling to create a formula that says Fcst V2 = Previous months F…
- Hi All, I was wondering if someone could help with below. if statement not reading dates prior to forecast start period. Forecast start period is Mar -19 Below should return 0 rather than Mar -19, why…
- Hi Experts, I have a requirement.i am confusing how to resolve this kindly help on this. In One module Row Axis - Product and Customer lists Column axis - Lime Item and time lists Page Axis - Measure …
- Hi All, I have an Import Module which has a Number and a Text Line Item. I have created another module with the Dimensions Provided Service and Cost Centre and in the Import Module created List fomatt…
- For the purpose of calculating lease contracts in IFRS 16 it's sometimes needed to have wide time ranges in the model. Currently, the amount of future years is limited up to 50 years and past years up…
- Hi, I have 3 modules, all sharing the same dimensions (period, transaction# and employee list). The first 2 modules contains line item "metric" both with output type list (same list), I need to see al…
- A pre-emptive alert for Anaplan function constraints based on the total number of cells to be processed would be useful to detect issues early in the ALM data transfer process avoiding the synchroniza…