For example, you can use the ISBLANK function to determine if an employee has an active health plan.
Syntax
ISBLANK(Value to test)
Arguments
Argument | Data type | Description |
Value to test | Date, time period, text, or list | The value to test for blankness. |
The ISBLANK function returns a Boolean result.
Syntax example
ISBLANK(Health Plan Start Date)
In this example, Health Plan Start Date is a line item with a date format. This function returns true if a value from the line item is empty, which means there is no Health Plan Start Date on record.
Calculation engine functionality differences
In Polaris, the ISBLANK function considers a text value that consists exclusively of carriage return characters to be a blank value.
In the Classic Engine, the ISBLANK function considers a carriage return to be a non-blank value.
Excel equivalent function
Related Anaplan functions
Examples
In this example, Health Plan Start Date source is period-formatted, using ISBLANK (Health Plan Start Date)
will return a boolean value of true if Health Plan Start Date is blank, and false if the value is anything else.
Jan 2021 | Feb 2021 | Mar 2021 | Q1 FY21 | |
Health Coverage Points | 75 | 98 | 115 | 288 |
Health Plan | Single | |||
Employee Deduction (%Salary) | 0 | 0 | 3.5 | |
Health Plan Start Date | Mar 2021 | |||
ISBLANK (Health Plan Start Date) |