How to convert dash value into zero value

[Pooja_D]

Hello All,

 I want to replace null, '-' Value with 0 (Numeric Zero) by Script level or sheet level.

I tried below syntax,

 If (isnull(YourExpression),0,YourExpression)

but it's not working.

Kindly suggest.

Thanks,

Pooja

[agigliotti]

Hi @Pooja_D ,

You can use:

Alt( YourExpression, 0 )

I hope it can help.

Best Regards