Decimal creating more digit in decimal part

[Jan_L]

Hi,

I am working on the agriculture related project.

We have the questions asking about farmer land use in the order

1. How many hectare of cultivated land you have ? answer in decimal
   1.1 How many hectare of CROP 1 cultivated land you have? answer in decimal
   1.2 How many hectare of CROP 2 cultivated land you have? answer in decimal

To validate the land - 1.1 +1.2 = 1 if not it showed the message that they need to redo it

We started having problem when data collector answer as :

1. How many hectare of cultivated land you have ? 2.64
   1.1 How many hectare of CROP 1 cultivated land you have? 2.32
   1.2 How many hectare of CROP 2 cultivated land you have? 0.32

But the validating message showed the sum of 1.1. and 1.2 as: 2.6399999999999997
which has 13th decimal- and this is not match with the total number which inputted in 1 which is 2.64

Hope that you guys can helps,

Jen

[wroos]

Hello @Jan_L,
Could you provide an extract of the related form part and a screenshot with data entry and mesaage, please?

[Jan_L]

Hi @wroos,

Here is my screenshot, and also attached is the xls form ,

Hope you can help,

Jen
Rice_Production_9May2022.xlsx (87.0 KB)

[Kal_Lam]

@Jan_L, maybe this post discussed previously should help you solve your issue:

How to validate the female and male entries with the total entry

Hi @Sylvain_DOAMBA, Simply expanding what @stephanealoo has advised. In the survey tab of your xlsform: [Image 1] Data entry screen as seen in Enketo: (wrong entry) [Image 2] Data entry screen as seen in Enketo: (wrong entry) [Image 3] Data entry screen as seen in Enketo: (correct entry) [Image 4] Reference xlsform: Calculation.xlsx (9.1 KB) Have a great day!

[Jan_L]

Thank you @Kal_Lam

The problem is that the form create 13 digits after decimal when I enter only 2 digits after decimal.

I enter 2.32, and 0.32 which expected the output (2.32 +0.32= 2.64) but Kobo generate this 2.63999999999997

I dont know why and how to solve this,
Best,

[Jan_L]

@Kal_Lam

I took a screenshot here, you can see the differences between other number

The have tried round up but it messed with other number, howcan I tell Kobo to take exact number that input when it has x.x2 + x.x2

Hope you can helps,
Jen

[hakan_cetinkaya]

Hi @Jan_L,

I’ve created a bug report in here including the problem you’re facing too:

Calculate Adding Extra Decimals

Description Calculate type question behaves differently on certain numbers and creates unnecessary and wrong decimal digits. Related: Decimal creating more digit in decimal part Steps to Reproduce A) Create an integer type question (Q1) Create a calculate question (C1) with a simple ${Q1} * 1.1 formula. Create a note to display ${C1} Write 100 to Q1. The note displays 110.00000000000001 instead of 110 B) Create two decimal questions Q2 and Q3 Create a calculate question (C4) with a si…

Feel free to test and provide additional details.
Best,

[Jan_L]

Thanks for additional point,

[Kal_Lam]

@Jan_L, could you also test this with the Collect android app to see if it behaves differently than Enketo? cc: @hakan_cetinkaya

[Jan_L]

Hi @Kal_Lam

Yes, the data collector using this on collect app and having the same issue.

Best