This topic is locked
[SOLVED]

 show total in a grid of all pages

9/19/2020 3:54:27 AM
PHPRunner General questions
J
Jan author

Hello everyone. There is the possibility to add a label in a grid to display the total (count, average, total)

But if a table contains multiple pages, then on each page there is the total of that page. I just want to show the total of all pages in one place. How can I fix this? Thanks

fhumanes 9/20/2020

Have you tried the dashboard option?
You can put a total panel and a grid panel.
Regards,
fernando

mbintex 9/20/2020

Put a snippet on your list page and in this snippet query for the total with DB::Query and echo the result.

D
david22585 9/20/2020

What I've done for accounting/money tracking was to create a separate column for the balance. Whenever a new deposit/withdraw is done, I read the last balance, add/subtract from that, and set that as the new balance on that row for that transaction. I've prevented editing the deposit/withdraw amounts, as to not taint the log with the ability to change data. If a correction is needed, a new entry must be made.

Sergey Kornilov admin 9/21/2020

I would also suggest using a code snippet for this purpose and calculating grand totals manually.

J
Jan author 9/21/2020

Thanks !