Hi all!
Does anyone know if it's possible to display null values in Analytics as 0? I'm trying to use conditional formatting in a pivot table, but this doesn't seem to be working with null values:
Any tips greatly appreciated!
All the best,
Rose
Try using a CASE statement.Something like: CASE WHEN sum([Ticket Count]) = null then 0 else sum([Ticket Count]) end
Thanks Neil! Just tried this but unfortunately it didn't work, getting the same results as above.
Try wrapping your Value within an ISNULL(). You might have to change it from = NULL to = TRUE.
Another idea is to use the IF function.IF ( <VALUE> = NULL, 0, <VALUE>)
If that still doesn't work, try replacing 0 with SUM(0).
I've just tried these formulas with zero success Thought they might help solve a similar issue I have.I want null running sum values to populate instead of remaining blank, any thoughts?E.g. above, I want the red value to appear, instead of being a blank cell (or in an even worse case when the pivot just skips null dates entirely).
Thanks all for your suggestions, Chris's suggestion worked for me in the end!