Display 0 and leave blank if null in a matrix

[barbforsman]

I have a measure that calculates the % of tasks that were completed early or on-time that I display in a matrix by week ending
Pct = ([Early] + [OnTime]) / [Total Tasks]

The problem comes when there is only 1 task in a week and it was late.  This would calculate to 0% for that week, but it does not show in the matrix.  I cannot replace blank or null values with 0, as I only want the field populated if there is data in it.

I have conditional formatting on the value's background color as shown in the screenshot, so I'm confused why it doesn't show the 0 value.

How do I make the 0 values show?

TIA

[edhans · Accepted solution]

zero values will show. Are you sure they are evaluating to zero, and not blank()? Drop the measure in a regular table and see what it looks like for those records

[edhans · Accepted solution]

zero values will show. Are you sure they are evaluating to zero, and not blank()? Drop the measure in a regular table and see what it looks like for those records

[barbforsman]

You are right!  It IS evaluating to blank.  But shouldn't 0/1 = 0 ?  I'm confused by this. How do I edit the measure to account for this?

[Anonymous · Accepted solution]

BLANK() / (any number) = BLANK().

From the table can be seen that [Early] = BLANK() and [OnTime] = BLANK(), so their sum is BLANK() as well.

Best
D

[barbforsman]

Thank you!  I changed the measure to evaluate from total tasks and then it works!

[Greg_Deckler]

[Greg_Deckler]

There should be an "is blank" option