Count that accomodates NULL

PJG
PJG Member
in Beast Mode

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!

Best Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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
    PJG Member
    Answer ✓

    Perfect thank you!

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @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
    PJG Member
    Answer ✓

    Perfect thank you!

Categories