i had problem when trying to sum up the values in my table. it does not contain any error but the problem is when i sum up the value in excel appear different from the value of my query.
Here is what i did
SELECT FORMAT(SUM(total_area),4) AS overall_area from ( SELECT country, FORMAT(SUM(accepted_area),4) AS total_area FROM `farm` GROUP BY country ORDER BY country ) as overallx
the output from this is 21,755.4188. when i sum up the actual value using excel is 16542.2742
this is my first time posting here. if i lack any information, please guide me.