Hi, I have written custom script report, all the field columns type is float, but the default total row is showing NaN instead of actual total number.
This suggests your case could be tricky to debug Navigating The Hell of NaNs in Python | by Julia Di Russo | Towards Data Science
convert values to float while returning data to the report.
You can use
from frappe.utils import flt
flt(your_value) it will return a float value