I need help with a calculated field

Q&A
, , ,
1

Hi community,

I need assistance with creating a calculated field. I have a dataset with a field called “Transactions” which has blank values, I want to create a calculated field that converts the blanks/nulls into 0(zero). How do I go about doing that

2

Hi @Andile

you can try

ifelse(isNull(Transactions) ,0 , Transactions)

Regards
Vetri