Does Bold BI have an equivalent of Tableau's ZN number function?

In Tableau, the ZN function returns the <expression> if it is not null; otherwise, it returns zero.
Does Bold BI provide an equivalent function for this behavior?


1 Reply

JV Jeevanandham V Syncfusion Team December 4, 2025 05:52 AM UTC

Yes, Bold BI has an equivalent function called IFNULL.

Details:

  • Syntax:
    IFNULL(expression1, expression2)
  • Functionality:
    This function returns expression1 if it is not null. Otherwise, it returns expression2.

Examples:

  • For string columns with NULL values:

    IFNULL([ShipRegion], 'Region not specified')

    This will display 'Region not specified' when ShipRegion is NULL.

  • For numeric columns with NULL values:

    IFNULL([ProductCount], 0)

    This will return 0 if ProductCount is NULL.


Loader.
Up arrow icon