cancel
Showing results for 
Search instead for 
Did you mean: 

package data store

AnnaW
Newcomer
0 Kudos

If I enter amount 19493476.01 it is stored as 19493476.010000002.
no. of digits after the decimal for account: 2
Could you please explain to me why this is happening?

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hi Anna,

This is normal behavior because FC stores amount by using float data type.

it shows double-precision floating-point numbers with up to 17 significant digits.

Please see the table definition below:

When you check the "Information on Data", it shows the real data saved in the table.

We introduced some potential problems when using this type of data store, like the control issue noted in the KBA

2077337 - Blocking controls due to decimals - FC

So we suggest you set a tolerance in controls in your category scenario to avoid this kind of problem.

Yang Yang