Wrong column sum if user has no All permisisons
Posted: 2021-03-21 21:54
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
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