Hello
Any help please !
Please see picture, how to remove those zero showing on both table and details view.
here my code
SELECT AVG(`infos_notes`.`total_notes`/`infos_notes`.`total_coef`) FROM `infos_notes`
WHERE `infos_notes`.`idinfo_note`='%ID%'
Thank you
AppGini 22.14 - Calculated field
Re: AppGini 22.14 - Calculated field
Hi,
you may try
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%'
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.
Re: AppGini 22.14 - Calculated field
Hi,
thank you sir, working !
Best regards,
thank you sir, working !
Best regards,