How to convert dash value into zero value

Pooja_D · ‎2023-09-27

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 · ‎2023-09-27

You can use:

Alt( YourExpression, 0 )

I hope it can help.

Best Regards

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it