Boolean calculated field: example

A calculated field (see Calculated) can be formatted to return Boolean values i.e. TRUE or FALSE. An example of the usefulness of such a field is the following.

Imagine you have two sets of data, for which you want to make a direct comparison item by item e.g. yearly income and expenditure over a five-year period. The Success column is a calculated field and contains this formula:

=IF(Income>Expenditure, True, False)

 

Income

Expenditure

Success

30,000

39,000

FALSE

28,000

27,000

TRUE

33,000

33,000

FALSE

100,000

40,000

TRUE