Count that accomodates NULL

PJG · 2024-08-22T14:37:09+00:00

There was an error rendering this rich post.

On some charts, for my summary value I need to add a custom Project Count Beast Mode, which is just this:

Value1+Value2+Value3 etc…

However, if any of the values are null, the count no longer works. Is there a workaround without having to exclude it from the Beast Mode?

Thanks!

Find more posts tagged with

@PJG You will need to add IFNULL around every value in your beast mode to force nulls to zero like this: IFNULL(Value1,0) + IFNULL(Value2,0) + …

Perfect thank you!

@PJG You will need to add IFNULL around every value in your beast mode to force nulls to zero like this: IFNULL(Value1,0) + IFNULL(Value2,0) + …

Perfect thank you!