I have created a simple form to capture data from our locations. I have set all the key numerical fields (used to capture transactions and hours) to be decimals. However, I have found that it is not capturing the decimal points and is in fact truncating off the decimals. I checked the fields and all are set to 1-2 but if I edit a record at a later date, it's truncated and if I pick 2 numbers it adds to the truncated amount (4.5 & 4.5 for instance add to 8).
Can someone assist me in getting this corrected?
Thanks,
Chris