Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hey i have 3 columns obtain mark , total mark and percentage. I am getting all the data from sql query and its working fine. But when we group by it adds everything and my percentage exceeds 100%. I have tried using average but its not accurate enough. Is there a way of finding percentage after using group by?
Thanks in advance, kindly help.
Hello,
all you need to do is add group_operator="avg" in you custom field :
example:
custom_field = fields.Float(
string='Rate %', group_operator="avg")
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
