Table Total show incorrect value than the visual total

I have 3 Tables 1. List of Items: which has all the names of Products 2. Sales: it has datewise sales at different rates depending on the customer, our Selling rates are not fixed. 3. Purchases: W...