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…
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…
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…
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…
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
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…
