Perform Operations like Sum/Average on the ListView in Odoo

But what if we want the total of all the quotations so far at the end of the list/tree view? Or if we want the total of all the invoices or if we want the total of any number of records. How to achieve that?

We can do so by using this simple syntax –

<field name=”amount_total”sum=”Total Tax included” widget=”monetary”

In the above code,

          amount_total= name of the field whose aggregate is to be calculated

          sum = name of the attribute

          widget = use for displaying the currency symbol

You can use any field you want to calculate the total of and not only just total, but you can also perform various other attributes on the tree view.

You can calculate the total of a field or the average value of a field in all the records etc.

Just specify the attribute you want to use, for example:

    -    sum for total

    -   avg for calculating the average

    -    min for the minimum value

    -    max for maximum value

Using this in the tree view would give you the total amount of all the records in that tree view.