AppGini Community Forums

Posted: **2022-12-09 16:28**

Hello

Any help please !

Please see picture, how to remove those zero showing on both table and details view.

: zero.jpg (108.08 KiB) Viewed 2083 times

here my code

SELECT AVG(`infos_notes`.`total_notes`/`infos_notes`.`total_coef`) FROM `infos_notes`
WHERE `infos_notes`.`idinfo_note`='%ID%'

Thank you

Posted: **2022-12-09 21:31**

Hi,

you may try

Code: Select all

SELECT ROUND(AVG(`infos_notes`.`total_notes`/`infos_notes`.`total_coef`),2) FROM `infos_notes`
WHERE `infos_notes`.`idinfo_note`='%ID%'

Posted: **2022-12-10 08:40**

Hi,

thank you sir, working !

Best regards,

AppGini Community Forums

AppGini 22.14 - Calculated field

AppGini 22.14 - Calculated field

Re: AppGini 22.14 - Calculated field

Re: AppGini 22.14 - Calculated field