Using Wildcards for function =SCOTT.QALL

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:


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!

Get started with a free trial