• If you want to use this in SSRS then you should use ISNOTHING statement.

    such as:

    IIIF( ISNOTHING([saleunit].value)=true, 1,0)

    You can also use the following code:

    IIF ( saleunit.value IS NOTHING,1,0)

    I hope it helps