In Excel we have Goal Seek function to set Target value of a calculated cell and based on that target value, excel performs reverse calculations and gives source value needed to achieve the target. No…
I have a model with sensitive HR data, and I need people which should not have access to identifiers of individuals to be able to enter data. I have a list of employees, and I need, somehow, to build …
Hi, I want to improve modele performance. I'm trying to improve IF statement. Here is two statement. Answer1 : IF A THEN IF B THEN 100 ELSE 50 ELSE 0 Answer2 : IF A AND B THEN 100 ELSE IF A AND NOT B …
I want to filter by a number line item to show just blank cells, but I cannot figure out how. I know the ISBLANK function is what I want to use, but it cannot be used on numbers. Is there a way to fin…
Hi Community members, I am looking for some alternatives to assign sequential ordering in Polaris model as the default "Rank" function is unavailable there. Thank you!
Hello All, Consider 2 General List List 1 Has A,B,C,D,E,F List 2 Has A,B,C,D,E,F And 2 module in which module 1 have dimension List 1 has value A=100, B=200. C=300, D=400, E=500, F=600 And module 2 ha…
I'm trying to setup a dependent dropdown for a line item that is a in list format where the list is a numbered hierarchy (mid-hierarchy). When I select my hierarchy level from the list, the checkbox f…
Hi, I have a question about best practices for setting up Modules for Dashboards. Currently we have LI's from different modules that we would like to display on one Dashboard. Is it best practices to …
Hello, I have 2 modules, each is using a different dimension (numbered list). Both modules have a line item which is a text. On the 3rd module that I'm trying to create, which is going to have the sam…
Hello i would like to set a basic if nested formula for estimating let's say commissions . If my limits are in units : 0-300 commission 0.2 301-500 commission 0.25 700 and above commission 0.30 Whats …
Hi everyone, I have two modules, let's say M1 and M2. In M1, the dimensions are Users and Activity (List of activities). In M2, the dimensions are Styles and Time. I have made a filtered (Style filter…
In Level-1 under "8.8.4 Activity: Add Formulas to Size, Margin Report Module" why do we need to change the Margin % line item Summary Method setting to Formula. What is the outcome or output of this c…
I am Having Query, in model building i have set the calender to months. but i want to see data in weeks what i have to do see weekly data and what are functions can i use or by changeing calender data…