# Django: Calculate the Sum of the column values through query

| | | | | |

👻 Check our latest review to choose the best laptop for Machine Learning engineers and Deep learning tasks!

I have a model

``````class ItemPrice( models.Model ):
price = models.DecimalField ( max_digits = 8, decimal_places=2 )
....
``````

I tried this to calculate the sum of `price` in this queryset:

``````items = ItemPrice.objects.all().annotate(Sum("price"))
``````

what"s wrong in this query? or is there any other way to calculate the Sum of `price` column?

I know this can be done by using for loop on queryset but i need an elegant solution.

Thanks!

👻 Read also: what is the best laptop for engineering students?

## Django: Calculate the Sum of the column values through query __del__: Questions

How can I make a time delay in Python?

I would like to know how to put a time delay in a Python script.

2973

``````import time
time.sleep(5)   # Delays for 5 seconds. You can also use a float value.
``````

Here is another example where something is run approximately once a minute:

``````import time
while True:
print("This prints once a minute.")
time.sleep(60) # Delay for 1 minute (60 seconds).
``````

2973

You can use the `sleep()` function in the `time` module. It can take a float argument for sub-second resolution.

``````from time import sleep
sleep(0.1) # Time in seconds
``````

## Django: Calculate the Sum of the column values through query __del__: Questions

How to delete a file or folder in Python?

How do I delete a file or folder in Python?

2639

`Path` objects from the Python 3.4+ `pathlib` module also expose these instance methods:

We hope this article has helped you to resolve the problem. Apart from Django: Calculate the Sum of the column values through query, check other __del__-related topics.

Want to excel in Python? See our review of the best Python online courses 2023. If you are interested in Data Science, check also how to learn programming in R.

By the way, this material is also available in other languages:

Olivia Lehnman

New York | 2023-03-24

Simply put and clear. Thank you for sharing. Django: Calculate the Sum of the column values through query and other issues with re Python module was always my weak point 😁. I just hope that will not emerge anymore

Davies Innsbruck

Shanghai | 2023-03-24

Thanks for explaining! I was stuck with Django: Calculate the Sum of the column values through query for some hours, finally got it done 🤗. Checked yesterday, it works!

Manuel Krasiko

Massachussetts | 2023-03-24

__del__ is always a bit confusing 😭 Django: Calculate the Sum of the column values through query is not the only problem I encountered. Will use it in my bachelor thesis

## Shop

Learn programming in R: courses

\$FREE

Best Python online courses for 2022

\$FREE

Best laptop for Fortnite

\$399+

Best laptop for Excel

\$

Best laptop for Solidworks

\$399+

Best laptop for Roblox

\$399+

Best computer for crypto mining

\$499+

Best laptop for Sims 4

\$

Latest questions

PythonStackOverflow

Common xlabel/ylabel for matplotlib subplots

PythonStackOverflow

Check if one list is a subset of another in Python

PythonStackOverflow

How to specify multiple return types using type-hints

PythonStackOverflow

Printing words vertically in Python

PythonStackOverflow

Python Extract words from a given string

PythonStackOverflow

Why do I get "Pickle - EOFError: Ran out of input" reading an empty file?

PythonStackOverflow

Python os.path.join () method

PythonStackOverflow

Flake8: Ignore specific warning for entire file

## Wiki

Python | How to copy data from one Excel sheet to another

Common xlabel/ylabel for matplotlib subplots

Check if one list is a subset of another in Python

How to specify multiple return types using type-hints

Printing words vertically in Python

Python Extract words from a given string

Cyclic redundancy check in Python

Finding mean, median, mode in Python without libraries