I have a use case to treat nulls as zero on a calculated field in MDA. It's simply A-B=C and in 25% of cases B is null. In those cases I would like to end up with C=A but there doesn't seem to be an option to treat null as zero in MDA calculated fields. Is this feature on a roadmap by any chance?
It's also worth mentioning in this data set the nulls in B need to stay null for downstream logic.
Question
Handling nulls in MDA calculated fields
+3Hi Dale,
Pretty sure you can get to this by using the Advanced Formula option for your calculated field. I think something like the following should work:
case when B is null then A else A-B end
Hope this helps!
Cheers,
Pele
Pretty sure you can get to this by using the Advanced Formula option for your calculated field. I think something like the following should work:
case when B is null then A else A-B end
Hope this helps!
Cheers,
Pele
+1Hi Dale,
Could you please use the default value option. It can be done while creating the field or we can edit the field and add the default value.
Could you please use the default value option. It can be done while creating the field or we can edit the field and add the default value.
1 person likes this
Hi Sai Ram,
While the default value option is a great solve for some cases I can't use it in this case. The null value indicates a unique condition we use to trigger a specific customer communication workflow, while a zero value indicates a reporting error in need of attention internally. The advanced formula does what we need for these conditions.
Thanks to both of you for your helpful suggestions
While the default value option is a great solve for some cases I can't use it in this case. The null value indicates a unique condition we use to trigger a specific customer communication workflow, while a zero value indicates a reporting error in need of attention internally. The advanced formula does what we need for these conditions.
Thanks to both of you for your helpful suggestions
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.