AppGini 22.14 - Calculated field

Discussions related to customizing hooks. Hooks are documented at http://bigprof.com/appgini/help/advanced-topics/hooks/
Post Reply
Moh Youba
Veteran Member
Posts: 228
Joined: 2017-03-12 09:31

AppGini 22.14 - Calculated field

Post by Moh Youba » 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
zero.jpg (108.08 KiB) Viewed 1106 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

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: AppGini 22.14 - Calculated field

Post by pbottcher » 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%'
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.

Moh Youba
Veteran Member
Posts: 228
Joined: 2017-03-12 09:31

Re: AppGini 22.14 - Calculated field

Post by Moh Youba » 2022-12-10 08:40

Hi,

thank you sir, working !

Best regards,

Post Reply