I tried to create a report but the percetage is shown as Blank if the Column value count is '0' i need to display the percentage as '0.0%'.
for eg :
Categories column is created as Bin in reports.I have selected the 'percentage of column' while doing the report.
Now need to display as
Appriciate you help
Use IFNULL(percentage_calc, 0) around your calculation.
If that doesn't work, simply CASE around your calculation to the tune of:
CASE WHEN denominator = 0 THEN 0 ELSE percentage_calc END