Subject Re: SUM From Akshat Kapoor <akshat.kapoor@kapoorsons.in> Date Thu, 11 Jan 2024 19:01:00 +0530 Newsgroups dbase.getting-started Good Evening Jerry, > I have a table with a numerical field named ENTRYFEE containing both positive and negative numbers in the format 1.00,2.00,-3.00, etc. > Every time I SUM this field I get 0.00 ? > > sum entryfee to x > ? x > > I am still new at this so much appreciation for a possible solution. Is there a possibility of null in the table. Null in even a single row can give unexpected results. sum amount to x ?x I checked the above command on my system and it is working fine. Try changing 1 row to a large number. It might be possible that the sum may actually be 0 Regards Akshat