Display zero instead of blank values
10 October, 2011
Hello,
is it possible to display zero values instead of blank in a Column based report? I want to achieve something similar to this (see below) but not for cross tab reports.
Thanks
is it possible to display zero values instead of blank in a Column based report? I want to achieve something similar to this (see below) but not for cross tab reports.
Thanks
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 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.
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
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