Number of digits in decimal different in DB and screen

0
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.
asked
1 answers
1

Hi Lisa,

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:

 

Cheers,

 

Marco

answered