2. PHPRunner General questions
  3. [SOLVED]  show total in a grid of all pages
This topic is locked
[SOLVED]

 show total in a grid of all pages

 		9/19/2020 03:54:27
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.
Please delete this account 9/20/2020

https://asprunner.com/forums/topic/21091-implementing-running-total-in-phprunner/
... for inspiration purposes only ...
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 !