Page 1 of 1

Wrong column sum if user has no All permisisons

Posted: 2021-03-21 21:54
by aarlauskas
I have a column with ‘Show column sum’ ticked to display the totals in TV. The totals show correct amount in TV, but if I select some records out of many listed in TV and click Print Preview button to only see the selected and print, the column sum then displays wrong figure. Let’s say I select 3 records from the list, each record has an amount of 15, 15 & 20. The column sum should display 50.00, but I get 750.00… No idea where these numbers even come from.
Now, this only happens if the user has table permissions set to Owner/ Owner/ Owner. If I do this as Admin or set user table permission as All/ All/ All then all works as it should.
I’m working on Expenses app (with Pascals and Jans help Thanks!) and I don’t really want to end up creating separate table for each user just because I need to give them full permissions.
Thanks
wrong_sum.JPG
wrong_sum.JPG (28.37 KiB) Viewed 2491 times

Re: Wrong column sum if user has no All permisisons

Posted: 2021-03-22 21:51
by SkayyHH
Hi,

I can confirm the bug. Are you reporting to Ahmed?

Also need a quick fix.

Greetings, Kai

Re: Wrong column sum if user has no All permisisons

Posted: 2021-03-23 06:12
by aarlauskas
Hi, no I did not, hope he reads the bug section :D Let me know if you have an update.

Re: Wrong column sum if user has no All permisisons

Posted: 2021-03-23 11:34
by a.gneady
Thanks for reporting this bug. I'll inspect it and try to make a fix in the next release.

Re: Wrong column sum if user has no All permisisons

Posted: 2021-03-23 11:56
by SkayyHH
Thank you very much!

Many greetings, Kai