Count that accomodates NULL

PJG

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!

MichelleH

@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) + …

PJG

Perfect thank you!

MichelleH

@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) + …

PJG

Perfect thank you!