
Calculation Functions
Calculation Functions
Discussion List
- How to hide columns using formula and which formula to use. For example, if my column value is equal to 0, it should automtically hide those columns and if cell value if equal to 1 then it should disp…
- I need a hand on this, should be something easy, hopefully someone can help me. I have a LIST of 62 items (Products) These products has their transactional data in another LIST. I have a Module A with…
- Hi, It could be very usefull if we had a pretty printer formula when creating formulas. I know we can check the formula indented when clicling on Drill Down, but it will be help us when we are develop…
- Hi, I am trying to build a training diary that should prompt an error message whenever public holidays are being selected. For example , there are 10 public holidays in a year. I need an error message…
- Hi, Lets start with a picture I have a module with brands, promotions and periods and some text, and would like to present them similar to the above picture. I have not seen or used a module where tex…
- Dear Anaplaners, What is the Anaplan equivalent function for the "Match" Excel function. I have a list "Age braket": 0 to 10 years 11 to 20 years 21 to 30 years Above 30 years I have 2 line items: Ag…
- I am creating a module that will be a template to import into our ERP. One of the line items is called 'Journalnum' which essentially needs to start at 1 and every line thereafter will be 2, 3 4, etc.…
- Hi All, I am working on particular client requiremnt. Where, the user dashboard has time as page selector (weekly format). Each time the user selects the particular week, I need to display that partic…
- Hi - I'm trying to calculate year over year growth in the time summary lines for my fiscal years. I can calculate year/year growth for each quarter (we are viewing our year by qtr only) using the offs…
- Hi I have 2 modules, EPOS Daily Module which has EPOS data stored with a 'cust-bvfsku' and a date, updated on a daily basis. Then I have a top level module EPOS Sales List Module, which has a single l…
Lookup Function -enhance this function with adding ability to ignore module's default dimensionality
Description of the enhancement required: Lookup Function - enhance this function with adding ability to ignore module's default dimensionality when using lookup. Pain - currently you cannot set anothe…- Hi, Module1 = dailysales has customer-product and date line items Module2 = periodsales has customer-product and startdate and enddate lineitems I want to SUM the sales from Module1 in Module 2 where …
- Is it possible to use a Lookup as criteria within another Lookup? Using Excel as an example; vlookup(vlookup(A1,B:D,3,0),Sheet3!B:D,0) I know the workaround would be to create a seperate list where th…
- It would be nice to be able to dynamically set cells on hold and/or set by default a hierarchy level on breakback "hold".
- This class gives the Anaplanner the fundamental steps to automate a hierarchy load from a Hub model to a downstream model. This training is intended for Anaplanners wanting to automate loading hierarc…
- Do not mark switchover automatically when creating a new line item.
- Suppose materials are purchased in January, and then in another Line Item, I would like the materials to be depreciated over 3 months (spread that purchase value out over 3 months)? Which formula shou…
- A number with the format 1234,56 will be converted to 1234.56 when using TEXT function on a number that has comma decimal point format.
- As a model builder and Admin i'm frustrated by the lack of flexibility when it comes to admin rights. 1.) Admin rights should be able to be assigned per model not per workspace, this gives newcomers t…
- Hi All, I've seen my question answered in bits & pieces, but hoping someone can give me a comprehensive walk through... My team is looking to build modules that will automatically assign current perio…
- Include in the formulas & functions the formula named "SLOPE" the slope function : Returns the slope of the linear regression line through data points in known_y's and known_x's. The slope is the vert…
- While applying the cumulate function on a list, the function works considering the original order of the elements, Is there a possible way to cumulate using the display order instead? This is required…
- Had a Partner ask if there is anything that does a "last non zero value" like our first non zero. Discussed ranking, but apparently that wouldn't work.
- I am currently looking to build a line item in a pre-existing module that shows a count of open shift request sent to only one employee. I have the "amount of shifts sent to" data as well as list of e…
- Hello - I am looking to calculate the date 90 days past an identifided date. I know there is an ADDMONTH and ADDYEARS calculation, but not an ADDDAYS, which would have been helpful. Is there another a…
- Hi When a boolean is selected in a dashboard to apply a filter based on this you have refresh the dashboard or create an action button that re opens the dashboard. It would be if when a Boolean was se…
- Hi, It would be an amazing feature to create a view on a dashboard and then push it back to the source module. Clients have asked for this. Thanks, Usman
- Hi It would be amazing if it was possible to format on a dashboard and then push the formatting back to the source module or saved view. Thanks, Usman
- All right, I did the very easy Makelink modules and added it to a dashboard. What my "click here" button should do is direct users to a Sharepoint on our network where we made/created documentation re…
- Adaptive Insights has this feature where an end user can "split" the value of a an input cell into several values to have that amount roll up and be displayed as a line item. Customers of Adaptive rea…