I recently created a few number fields. They were created as text fields and then I went back and changed them to Number type in the DB Manager.
I needed to add these fields together. What I found was two fields out of the group were not acting completely like numbers. This was of course an issue.
The only fix was to delete the fields and create new ones that were Number type from the start. Has anyone experienced this before? Known bug? FMPA 14.04