メインコンテンツまでスキップ

Information Calculated Fields

Information calculated fields are meant to be used to test the value of a selected field. They are particularly useful with large spreadsheets because you can check what type of information you are working with before performing a second calculation.

Information functions:

Function NameSyntax and Sample
empty: empty can be used to insert a column with empty cells. There are no arguments to configure.Syntax: empty()
Sample: empty()
isempty: isempty evaluates the specified expression, and checks if any row in your data source has empty values.Syntax: isempty({value})
Sample:isempty([ResignedDate])

isempty

Unlike empty, isempty will check the field you select and check every row in your datasheet. If there are no values in a row, the output will be 1; if there are values, you will see 0.

Sample

Function NameSyntaxSample
isemptyisempty({value})isempty([ResignedDate])

Let's look at four lines in the HR Dataset 2016 spreadsheet.

EmployeeIDFullName…​Resigned Date…​Calculated Field
1.00Joan Baez…​…​1.00
4.00Zurcher Reid…​28-Dec-2016…​0.00
22.00Zornes Hall…​…​1.00
35.00Zdiarski Campbell…​09-Apr-2016…​0.00