Hi,

This should be possible with a calculated field.
You can create a CASE statement so that if NULL results are returned, you can display '0.00'.

Eg.




In the example above, instead of displaying the field 'Cancellation Fee', you will simply display the calculated field.

Please let me know if you have any troubles with this.

Regards,
David

This is helpful - but won't work in my scenario because I want to then aggregate the field.

I have attached a screen shot of what I am trying to accomplish - my Completion Rate column is an "advanced function" that divides the WasCompleted column by the Count of Opened column. I need the Completion Rate to have zeros instead of blanks and THEN I need to be able to aggregate the Completion Rate column.

First screen shot shows all columns used, second screen shot shows how it will all display once the aggregations are applied.

This is helpful - but won't work in my scenario because I want to then aggregate the field.

I have attached a screen shot of what I am trying to accomplish - my Completion Rate column is an "advanced function" that divides the WasCompleted column by the Count of Opened column. I need the Completion Rate to have zeros instead of blanks and THEN I need to be able to aggregate the Completion Rate column.

First screen shot shows all columns used, second screen shot shows how it will all display once the aggregations are applied.

Thanks!
Faere