Knowledge Base

Workbooks includes filters and report criteria to allow you to check if a field ‘is blank’ or ‘is not blank’, but sometimes, you need to do this check within a calculated column. There are a

Workbooks has a number of functions that can be used within calculated columns to help simplify reporting on Financial Year information for records. These functions can be especially useful when working with Financial Reports to

When creating a calculated column it is possible to add comments within the code. This is so that Users can leave behind a brief explanation of what the calculation does so that it is easy

It is possible to replicate all of the search filters from a Landing Page within a Report Calculated Column. This article will provide some examples of the formats you will need to follow in order

This page will cover some of the most common Date Functions that you may use when creating Reports. These can then be used to look at progress over time, or the time between updates on

This post is to help you become more familiar with the IF statement within a Report, it will cover how it can be used in a Reporting. IF statements are a great way to see

The CASE statement is similar to the IF statement. However, it allows you to apply more complicated logic than a simple yes or no response. The structure of a CASE Statement is as follows: You

How to use Calculated Criteria in order to refine the results to only include records in a report that fit one or another criteria, which don’t refer to the same field.