Number of digits in decimal different in DB and screen
Hi everyone, I thought that no matter what, a decimal will be saved in the database with 8 digits. This is also a requirement. We need to show 4 digits on screen, but when a user enters >4 digits, we want to save it with 8 digits and do calculations with 8, only to round on screen. Now I figured that when on screen you say decimal mode is fixed with a precision of 4, the decimal will be saved with 4 digits. Is it possible to show something different than is saved? Thanks in advance.
Lisa van de Put
Yes, it is possible to store the decimal in 8 digits behind the decimal point.
When displaying the decimal that is stored, you will define the format it is shown.
When creating the input field I would use auto, not fixed to 4: