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).