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.
Was this helpful?
No