We have added a new feature to function =SCOTT.QALL . Wildcards are now supported as values for parameters Class, Customer, Department, and Vendor. Wildcards open up all sorts of possibilities for building powerful dashboards to analyze financial results.
A wildcard allows you to include ALL transactions for a parameter, regardless of the value of the parameter. For example, you may wish to include all Customers, but limit the Class, Department, and Vendor to specific values. This might look like:
=SCOTT.QALL(A1,A2,A3,”*”,A5,A6,A7,A8)
Note that when entering the wildcard directly into your formula, you will need to enclose it in quotes. However, if you specify it by referencing a cell (recommended), the cell referenced should only contain the * symbol.
Here is a short video demonstrating this new feature.
Have fun using wildcards to create financial art!