I am having trouble with a table in my report. I set up a conditional formating for the title coulumn based on a True/False column converted to to 1/0 to show red when that value is 1 and to do nothing when the value is 0. It is working fine, except on a few rows. The table in question has a title field, the formated field, and two number fields counting related records from two other tables. For rows where there are no related records, resulting in a null on the count fields, The conditial formating does not display. The titles field and the field the formating is based on come from the same table so they do not rely on any relationships with the count columns.
I did test what happens without the count columns. If I remove the other columns from the table, leaving just the title, the formating works flawlwssly. However, I want those counts to be there as one column tables are not the most useful things out there.
Why would that formating not show on the rows with nulls when the nulls are completely unrelated to the formating?
