S A U | Reputations

FYI. Starting from version 2022.2.0, the use of new QM's feature - check-boxed boolean constrained input - will allow you not to use canvas switches. Slicers become fully scalable without any manual manipulation...

Gilbert, glad I was able to help you! Good luck

Gilbert, let’s explicitly specify the third parameter of select() function (#true#): * * * Hope the formulas will be workable in this case. Good luck

Gilbert, both formulas are working, as indicated by green check marks in upper left corners of the pictures. Good luck

Gilbert, try another formula version, plz: * * It looks like a Mac version of QM doesn't recognize such formula syntax's. These two formulas are complete equivalents. The first one is just shorter. 1....

Hi Gilbert, try this: Good luck

Dot Quadrant Chart by means of Scatter (2D): a Square Shape. Rather than regular matrices, Scatter (2D) chart is used here as a quad indicator. Plus a little bit trigonometry... and here's what happened...

FYI, you don't have to add an extra YearNumb item to allow Max() or Min() to refer to a category by current its element rather than by all their list. Variant 1: Max(List(Value(@Year)) - 2011, 0), or Variant...