FieldError at /dashboard/
Cannot compute Sum('total_amount'): 'total_amount' is an aggregate
Request Method:	GET
Request URL:	http://7a7f08a3-f24d-4ac6-bd06-d0386ed34d90-00-134azppx5f9s7.worf.replit.dev/dashboard/
Django Version:	5.0.2
Exception Type:	FieldError
Exception Value:	
Cannot compute Sum('total_amount'): 'total_amount' is an aggregate
Exception Location:	/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages/django/db/models/aggregates.py, line 73, in resolve_expression
Raised during:	customers.views.DashboardView
Python Executable:	/home/runner/workspace/.pythonlibs/bin/python
Python Version:	3.10.18
Python Path:	
['/home/runner/workspace',
 '/nix/store/zz7i75jb78idaz0rb1y1i4rzdyxq28vf-sitecustomize/lib/python/site-packages',
 '/nix/store/xpxqdrjisrwlpm2dnisd2r08iq2qx930-python3.10-pip-25.0.1/lib/python3.10/site-packages',
 '/nix/store/rwxj49zghamyhy07b67yhiq64bmznvmm-python3-3.10.14/lib/python3.10/site-packages',
 '/nix/store/jyvjawqnhnqhwrsinpvx1av7q2p2fcym-python3-3.10.18/lib/python310.zip',
 '/nix/store/jyvjawqnhnqhwrsinpvx1av7q2p2fcym-python3-3.10.18/lib/python3.10',
 '/nix/store/jyvjawqnhnqhwrsinpvx1av7q2p2fcym-python3-3.10.18/lib/python3.10/lib-dynload',
 '/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages',
 '/nix/store/jyvjawqnhnqhwrsinpvx1av7q2p2fcym-python3-3.10.18/lib/python3.10/site-packages',
 '/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages',
 '/nix/store/dl6xr8gz142jqd6gzmh43r4za60hfv0c-python3.10-setuptools-80.7.1/lib/python3.10/site-packages']
Server time:	Thu, 31 Jul 2025 14:29:01 +0300
Traceback Switch to copy-and-paste view
/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages/django/core/handlers/exception.py, line 55, in inner
                response = get_response(request) …
Local vars
/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages/django/core/handlers/base.py, line 197, in _get_response
                response = wrapped_callback(request, *callback_args, **callback_kwargs) …
Local vars
/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages/django/views/generic/base.py, line 104, in view
            return self.dispatch(request, *args, **kwargs) …
Local vars
/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages/django/contrib/auth/mixins.py, line 73, in dispatch
        return super().dispatch(request, *args, **kwargs) …
Local vars
/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages/django/views/generic/base.py, line 143, in dispatch
        return handler(request, *args, **kwargs) …
Local vars
/home/runner/workspace/.pythonlibs/lib/python3.10/site-packages/django/views/generic/base.py, line 226, in get
        context = self.get_context_data(**kwargs) …
Local vars
/home/runner/workspace/customers/views.py, line 104, in get_context_data
                'payment_collection_rate': self.get_payment_collection_rate(), …
Local vars
/home/runner/workspace/customers/views.py, line 194, in get_payment_collection_rate
        total_invoices = Invoice.objects.filter(