Populating Cells with Default Values

This article gives you an example of how to use advanced filters to populate blank cells with a default value in Bullhorn Reporting (previously Canvas).

Example

You want to show if your Recruitment Type (located in customText18) has a value. Use either of the following in an advanced filter to populate a "1" or "0", based on whether a value exists in the column:

Copy

ISNULL

CASE WHEN ISNULL([PRESENTATION VIEW - COMPANY ANALYSIS].[COMPANY].[customText18], '') = '' THEN 0 
WHEN [PRESENTATION VIEW - COMPANY ANALYSIS].[COMPANY].[customText18] = 'Unknown' THEN 0 ELSE 1 END

 

Copy

COALESCE

CASE WHEN COALESCE([PRESENTATION VIEW - COMPANY ANALYSIS].[COMPANY].[customText18], '') = '' THEN 0 
WHEN [PRESENTATION VIEW - COMPANY ANALYSIS].[COMPANY].[customText18] = 'Unknown' THEN 0 ELSE 1 END

See Creating Advanced Filters in Bullhorn Reporting (Previously Canvas) for more information on advanced filters.