Hello
I want to create 5 fields of selection type: N1, N2, N3, N4 and N5. Each field must have 3 possible selections. "Yes", "No" and "Do not apply"
And I need to calculate in another field the percentage of "Yes" answers out of the total fields.
Is it possible with Odoo Studio?
Thanks
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
Hi,
The Selection fields can be directly created with the Odoo studio. Drag and drop 'Selection' from the Add > New fields selection and in the field properties popup add the required selection options - 'Yes', 'No', 'Do not apply'.
For the percentage calculation a Decimal(float) field can be used. We have to define a compute function for this float field. For that select the field, cllck on the 'More' option under the Properties tab. In the form view , you can see the options to provide Dependencies and Compute function.
In the dependencies provide the names of the 5 selection fields separated by comma. For example - x_studio_n1, x_studio_n2,x_studio_n3, x_studio_n4,x_studio_n5.
In the Compute field provide the code to calculate our percentage.
Sample Code:
for record in self: yes_count = 0 if record.x_studio_n1 == 'Yes': yes_count += 1 if record.x_studio_n2 == 'Yes': yes_count += 1 if record.x_studio_n3 == 'Yes': yes_count += 1 if record.x_studio_n4 == 'Yes': yes_count += 1 if record.x_studio_n5 == 'Yes': yes_count += 1 record['x_studio_percentage'] = yes_count*100/5
Regards
Thank you so much, I prove it and it works perfectly¡
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
DaftarPost Terkait | Replies | Tampilan | Aktivitas | |
---|---|---|---|---|
Create a consecutive field
Diselesaikan
|
|
1
Nov 21
|
2668 | |
|
0
Jul 22
|
1717 | ||
|
0
Mei 22
|
2164 | ||
|
1
Apr 25
|
1193 | ||
Restrict Studio ,to users
Diselesaikan
|
|
1
Des 24
|
2685 |