Base resetting field data to zero when saving record

[JakeDM]

I am using LibreOffice 7.0.6.2 on macOS Catalina.

I have built a small table that includes a percent field. Whenever I enter a number in the field, I hit the “Save Record” button and the field resets to zero. It does not matter if I enter the info on the form or directly into the table, I get the same behavior. A similar issue happens with a field formatted to show currency or a simple number with 2 decimal places. Can anyone explain why this is happening or how to stop it from happening? I need the data to remain as I enter it for later use.

Since I am new here, the system will not let me attache a file to this post. And I can only include one screenshot. Here is what I am working with:

The third record is the data I am entering. The first two records are what happens when I move onto the next record. The last field is just blank.

[RobertG]

Which field type and field properties do you use for Percent1. Should be DECIMAL and should have 4 decimal places, because 41.13% is the same as 0.4113.

Does Percent.odb (3.9 KB) work on your system? Works here well on OpenSUSE 15.2.

[Ratslinger]

@JakeDM Can duplicate your problem if the field type in the table is set to Integer or Numeric (default = 0 decimals). Should be as noted by @RobertG

[JakeDM]

@RobertG and @Ratslinger, thank you for your help. Your Percent.odb file did work on my system. After seeing your responses and looking at the sample, I saw that I did have the field type set to Integer instead of Decimal. Your solutions worked perfectly! Thanks again!