How to Show Total, avg etc at bottom of Column in script report?

Sangram · April 21, 2017, 5:36am

ballmill_DVRG this is your result.

add your logic here. Calculate the average of columns you want. Then add calculated Average Column to it and return the result.

Check query_report.py

github.com

frappe/frappe/blob/develop/frappe/desk/query_report.py#L166-L215


      
          
          	return {
          		"script": render_include(script),
          		"html_format": html_format,
          		"execution_time": frappe.cache.hget("report_execution_time", report_name) or 0,
          		"filters": report.filters,
          		"custom_report_name": report.name if report.get("is_custom_report") else None,
          	}
          
          
          def get_reference_report(report):
          	if report.report_type != "Custom Report":
          		return report
          	reference_report = frappe.get_doc("Report", report.reference_report)
          	return get_reference_report(reference_report)
          
          
          @frappe.whitelist()
          @frappe.read_only()
          def run(

This file has been truncated. show original

Thanks,
Sangram