AppGini Community Forums

hello, we use appgini a couple days ago

how to use "Select Coalesce" or maybe another querry syntax ? we need to create a count of record in every group in a one line querry. and then in sub-total row, we need to create different color backgroud.

we attach my table. it woud be very appreciate if we can find solution in here.

Hello Azizan,

i couldn't find any query syntax to select what you want , but you can use App Gini custom pages , and count them manually

an idea for counting , you can select distinct company values and itterate over the table to count them