Add Total Row - Script Report is not working?

Frappe Framework
1

Enabled (ticked) the “Add Total Rows” in script report, but system not showing total amount at the bottom in Frappe . what may be the reason for not showing total amount after hosting Frappe hosting

Prepared Report - Not ticked the Prepared Report report option, But after hosting system changing to prepared report. ?

In local system its both working fine. the issues is noted after Frappe Hosting.

2

Field type must be Float or similar.
The data must not be the same. If some rows have null (ie None) value, Frappe may not calculate the sum. Check and try to avoid dirty data in that query.

3

Thanks for the support
what about the data type → Currency ?

4

Data type is Float and None data is not there, still not showing total in reports

Report with setting

image

Report with data
image