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")
Tạo tài khoản ngay hôm nay để tận hưởng các tính năng độc đáo và tham gia cộng đồng tuyệt vời của chúng tôi!
Đăng ký
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
