It is found, when using bionic rule formula to do for example, Field 1 + Field 2 + Field 3. If one of those values is null, total would come out to null as well.
Putting in another example, a 1 + 2 + " " , result will be null. Please add an accommodation for bionic rules to handle nulls.
You can use pivot as a workaround, but Pivot only allows it on one field at a time per task.
Question
Substitute Nulls with Zeros for Bionic Rule Formula to Bring Results
+1
+4Big time +1
Hi Kevin,
Current formula builder component will enforce the user to use the same data type fields to be added. For example in an expression we will allow only numeric field/value or resultant numeric function. This will ensure that numbers and string values can not be clubbed together.
However per my knowledge, at the time of designing the rule, we may not be able to predict whether the field value in record holds null or zero value. This is because the rule will not be executed once.
We will think about the possibilities of gracefully handling this situations and update on this. One quick thought which might help is: Have a setting that will ensure null/empty values adjusted "Adjust/Omit empty values".
Current formula builder component will enforce the user to use the same data type fields to be added. For example in an expression we will allow only numeric field/value or resultant numeric function. This will ensure that numbers and string values can not be clubbed together.
However per my knowledge, at the time of designing the rule, we may not be able to predict whether the field value in record holds null or zero value. This is because the rule will not be executed once.
We will think about the possibilities of gracefully handling this situations and update on this. One quick thought which might help is: Have a setting that will ensure null/empty values adjusted "Adjust/Omit empty values".
1 person likes this
Hi Kevin,
I agree that current way of handling nulls in expressions and functions might be a blocker in getting the desired output.
While we are working on some new formula functions for fall release, we will try to accommodate NullToZero() function or introduce a flag "Treat null values as zero" for functions and expressions which takes numeric values as source.
I will keep you posted on this.
Regards,
Jitin
I agree that current way of handling nulls in expressions and functions might be a blocker in getting the desired output.
While we are working on some new formula functions for fall release, we will try to accommodate NullToZero() function or introduce a flag "Treat null values as zero" for functions and expressions which takes numeric values as source.
I will keep you posted on this.
Regards,
Jitin
+4Hi Jitin - this would be a great solution for the specific problem I'm encountering with my customer. Thanks for considering.
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.