Ability to Color cells based on cell value

ERPNext Reports
18

Hi,

I am trying to set a background color of rows in a report based on certain rules but the problem is that the color removes the field values if the fieldtype is set to none in the report.

Also the date field is removed with this see the image below:

image.png952×196 14.3 KB

The report in particular is found here

Basically the coloring is working perfectly for Link, Currency and Float type fields but its not working for fields where there is no specification of the type of field and also for DATE fields

Please let me know if there is something wrong with my code or something is wrong with backend code.

The code to give background color is as below:

"formatter":function (row, cell, value, columnDef, dataContext, default_formatter) {
	value = default_formatter(row, cell, value, columnDef, dataContext);
	if (dataContext.DN_Price == 0) {
		var $value = $(value).css("background-color", "#75ff3a");
		value = $value.wrap("<p></p>").parent().html();
	}
	return value;
}