A calculated column (recently renamed ‘Report Formulas’) can be added to any Quick Base report. The report formula is similar to a formula field, but is added as a column to your report and can only be used within the confines of the report where it was created. If you not familiar with Report Formulas, click here for a brief background.
If you’re familiar with Report Formulas you already know they can be used to; Calculate total costs, display images, return a boolean depending on if a criteria is met and more. But did you know that Report Formulas can also be added to your report filters?
So what are some good examples where we might use Report Formulas in a report filter? The applications are fairly wide-ranging. Here are just a few examples:
Let’s look more closely at our first example: Extract months from dates to allow users to filter by a particular month. In this scenario we’ll use a formula to determine the month of each of our project start-dates. Then we will use the results of the formula to filter for Projects starting in the month of February.
Currently our report looks like this:
If we wanted to see all the projects starting in February 2019 we could easily set a filter within the report that looked like this:
However, if I expand this filter to look as far back as 2010, I’ll have to add similar filters an additional 8 times (one for each year). Creating a Report Formula and using it as a filter presents a better option.
To setup our Report Formula and Report Filter, take the following steps:
Author: Jake Rattner (firstname.lastname@example.org)
Date Submitted: 4.18.19