In some of our table objects we're applying conditional formatting using a background color expression. Specifically, we're applying color banding to the rows of the table to make things easier to see. We've noticed that for cells that are null, the formatting doesn't work.
This works for everything but null cells. A screen shot of the issue is below. These nulls aren't in the source data - they are "app-side" nulls caused by a lack of data points for certain combinations of fields/tables. So I don't think we can handle this in the load script.
Any ideas on how we might tweak our above formula to handle these nulls?
Unfortunately, that won't work in our case. The nulls in this particular field aren't in the source data - they're being caused on the app side. For nulls in fields/cells in the source data, we typically try to handle them in the load script. However, there are also nulls that show up in the app, due to combinations of products/dates/etc. that didn't even exist in the source data. For these app-side nulls, I've never found a good solution on how to handle them.