# Maths (sum) column is correct, but is incorrect in the chart **URL:** \ **Category:** Ask for Help\ **Created:** [May 30, 2024, 9:36pm UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763 "2024-05-30T21:36:05Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\ **Post date:** [May 30, 2024, 9:36pm UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/1 "2024-05-30T21:36:05Z")
I have 4 categories of sales that I have rolled up, and then added together to sum up total sales. The calculations are correct in the table, however when I draw a chart, the amount is incorrect. It seems to be excluding one of the categories from the total. Please help with some ideas to correct this. This is my app [https://easychicken.club/](https://easychicken.club/) The dashboard is where I’m having issues. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 30, 2024, 11:45pm UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/2 "2024-05-30T23:45:49Z")
I just tried creating an account in your app but as I have not logged any data, my dashboard seems to be empty. Can you send some screenshots on how you’re configuring the rollups and the charts? It sounds to me that your chart limit field is contributing to this. ---
**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\ **Post date:** [May 31, 2024, 5:54am UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/3 "2024-05-31T05:54:43Z")
Hello! Yeah sure. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a587a78d8f07b0f046b228cbf8e0305633cfcff5.jpeg) The total is correct here. But the offal sales which you can see here, are not pulling through. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/a/cae0c27a049ca3dd37b2efc7dd4441c3eaf09859.png) One is supposed to be 5000 more, the other is supposed to be 52000 more. This is the case for both components and charts on the dashboard. I do note though that it seems to be incorrect in the single row data like below ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e9410a822d5c9d89e42ea5e415c39886108e468.png) What causes this difference between the table and the single row data? ---
**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\ **Post date:** [May 31, 2024, 6:08am UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/4 "2024-05-31T06:08:39Z")
Interestingly, the other thing I am noting is that there are some issues in the original table. It seems some of the entries don’t have the user email. That would be a proper issue since the email is the row owner. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/a/2a98786b54d08021a6c0356608ea2c87e67eda10.png) I need to test this with new data. It probably happened in the many iterations. Thanx for checking. I will let you know if it persists. ---
**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\ **Post date:** [May 31, 2024, 7:13am UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/5 "2024-05-31T07:13:21Z")
I’ve now uncovered a super challenge. How do I delete data associated with an entry on all tables. I.e. I’ve deleted the flocks to start from scratch, but the other data like sales and losses were not deleted. How would I delete data in multiple tables at the same time? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 31, 2024, 7:23am UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/6 "2024-05-31T07:23:30Z")
Create a query or multiple relation to each of the tables concerned, and use a series of delete row actions through those queries/relations. ---
**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\ **Post date:** [May 31, 2024, 1:30pm UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/7 "2024-05-31T13:30:52Z")
Worked perfectly ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/c/ec4438c1237af7f3d9b550dac9fbe49a79de89ce.png) Much appreciated! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 31, 2024, 1:52pm UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/8 "2024-05-31T13:52:06Z")
So does this solve your earlier problem? ---
**Author:** ![FloMo](https://avatars.discourse-cdn.com/v4/letter/f/f19dbf/32.png) [@FloMo](https://community.glideapps.com/u/FloMo)\ **Post date:** [June 1, 2024, 6:33am UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/9 "2024-06-01T06:33:23Z")
The earlier problem is sorted. I used this to delete all data and start with new inputs. It turns out the calculations themselves are correct. Thanx a mil for checking. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 1, 2024, 1:36pm UTC](https://community.glideapps.com/t/maths-sum-column-is-correct-but-is-incorrect-in-the-chart/73763/10 "2024-06-01T13:36:43Z")
Great to hear!