I have a report where I need the blank values for a measure to show with zeros instead and I cannot get any of the normal calculated fields to populate the zero value. I would have though the ZN or IFNULL would have resolved this issue but neither get me the zero in the field I need.
Any help would be appreciated.
This works to populate the record with a zero, which is half way to what I need. Now this issue is that, for some reason, when I put that new calc field in the report it doesn't allow me to rank them, and doesn't populate the marks portion in the same way.
They are both formatted as numbers but for some reason, the calculated one doesn't default to the SUM value when pulled in to the report so I cannot format the data as needed.
