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

[Okard]

Hello @Kal_Lam

Do you have any update on this?

Best,

[wroos]

Hello @Okard,

• Would you mind to share the related part of your form, please.
• Could you test the issue on Collect, as Kal_Lam suggested?
• Do you have the same issue when you uae a decimal instead of the calculate type?
• What was the problem when you used round()?

[Okard]

Hello @wroos

Please see the attached for the form,

You can reproduce the problem with -

Yes, I am using both collect and Enketo to test, and it produce the same problem.

When I used round up the problem is with the number that I dont want to round them up like 3.98. I dont want them to be 4 for example

Best,
Okard
Rice_Production_9May2022.xlsx (87.1 KB)

[wroos]

Hello,
Did you try round(YourDecimal, 2)?
See https://getodk.github.io/xforms-spec/#fn:round.

[Okard]

Hi @wroos ,

Sorry for late response. I did use the round up for the input in _1_1 , _1_2, _1_3, and 1_4 and the response was incorrect and it was when I think round up was not the function

But I have removed them from the mentioned question, and only use round up with result of the sum (_1_1 + _1_2 + _1_3 + _1_4) and it works.

Hope that the enumerator will not add more than 2 digits:) , thanks for your help a lot.

Best,
Okard