Converting logical values to numbers

In order to calculate on logical values, it is often useful to pretend that TRUE is 1 and FALSE is 0. Just as with text, to perform the conversion, you can use the N() function. This allows you to count the number or proportion of true values.

• The SUM() of the ones gives you the count of true values.
• The AVERAGE() of the ones and zeros gives you the proportion of true values.