I am designing a form for a survey which requires referencing some

variables from a CSV file. The problem i have is that the decimals are

being rounded to 1 decimal place (e.g. 3.4) instead of showing all the

decimals(e.g. up to 10 decimals or more i.e. 3.487698325487623). I dont

want the values to be rounded when pulling this data from a CSV file.here

is my code:" pulldata ('reference', 'nutrition_index', 'age_r',

'${age_in_days}' ). Please help

Hi Vincent,

The data is pulled into a calculate, right? What happens if you output

that calculate? Do you get all the numbers?

Yaw

## ยทยทยท

On Fri, Oct 21, 2016 at 2:29 PM, Vincent Mkandawire wrote: > I am designing a form for a survey which requires referencing some variables > from a CSV file. The problem i have is that the decimals are being rounded > to 1 decimal place (e.g. 3.4) instead of showing all the decimals(e.g. up to > 10 decimals or more i.e. 3.487698325487623). I dont want the values to be > rounded when pulling this data from a CSV file.here is my code:" pulldata > ('reference', 'nutrition_index', 'age_r', '${age_in_days}' ). Please help > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.yes data is pulled into a calculate. But the output is rounded to 1 decimal

place. I am not getting all the decimals.

## ยทยทยท

On Monday, October 24, 2016 at 5:08:05 PM UTC+2, Yaw Anokwa wrote: > > Hi Vincent, > > The data is pulled into a calculate, right? What happens if you output > that calculate? Do you get all the numbers? > > Yaw > > On Fri, Oct 21, 2016 at 2:29 PM, Vincent Mkandawire <yelu...@gmail.com > wrote: > > I am designing a form for a survey which requires referencing some > variables > > from a CSV file. The problem i have is that the decimals are being > rounded > > to 1 decimal place (e.g. 3.4) instead of showing all the decimals(e.g. > up to > > 10 decimals or more i.e. 3.487698325487623). I dont want the values to > be > > rounded when pulling this data from a CSV file.here is my code:" > pulldata > > ('reference', 'nutrition_index', 'age_r', '${age_in_days}' ). Please > help > > > > -- > > -- > > Post: opend...@googlegroups.com > > Unsubscribe: opendatakit...@googlegroups.com > > Options: http://groups.google.com/group/opendatakit?hl=en > > > > --- > > You received this message because you are subscribed to the Google > Groups > > "ODK Community" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to opendatakit...@googlegroups.com . > > For more options, visit https://groups.google.com/d/optout. >Hi Vincent,

There is likely a bug in your form, your CSV, or in the version of

Collect you are using.

Attached is an example using ODK Collect 1.4.11 where I enter a key (a

or b) and get a value with decimals from a lookup CSV.

Yaw

numbers.xlsx (23.8 KB)

lookup.csv (56 Bytes)

## ยทยทยท

On Fri, Oct 28, 2016 at 8:24 AM, Vincent Mkandawire wrote: > yes data is pulled into a calculate. But the output is rounded to 1 decimal > place. I am not getting all the decimals. > > On Monday, October 24, 2016 at 5:08:05 PM UTC+2, Yaw Anokwa wrote: >> >> Hi Vincent, >> >> The data is pulled into a calculate, right? What happens if you output >> that calculate? Do you get all the numbers? >> >> Yaw >> >> On Fri, Oct 21, 2016 at 2:29 PM, Vincent Mkandawire wrote: >> > I am designing a form for a survey which requires referencing some >> > variables >> > from a CSV file. The problem i have is that the decimals are being >> > rounded >> > to 1 decimal place (e.g. 3.4) instead of showing all the decimals(e.g. >> > up to >> > 10 decimals or more i.e. 3.487698325487623). I dont want the values to >> > be >> > rounded when pulling this data from a CSV file.here is my code:" >> > pulldata >> > ('reference', 'nutrition_index', 'age_r', '${age_in_days}' ). Please >> > help >> > >> > -- >> > -- >> > Post: opend...@googlegroups.com >> > Unsubscribe: opendatakit...@googlegroups.com >> > Options: http://groups.google.com/group/opendatakit?hl=en >> > >> > --- >> > You received this message because you are subscribed to the Google >> > Groups >> > "ODK Community" group. >> > To unsubscribe from this group and stop receiving emails from it, send >> > an >> > email to opendatakit...@googlegroups.com. >> > For more options, visit https://groups.google.com/d/optout. > > -- > -- > Post: opendatakit@googlegroups.com > Unsubscribe: opendatakit+unsubscribe@googlegroups.com > Options: http://groups.google.com/group/opendatakit?hl=en > > --- > You received this message because you are subscribed to the Google Groups > "ODK Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.Thank you Yaw Anokwa for the help. I figured out that there is a problem

with Microsoft Excel in Exporting data with decimals to an CSV file. so i

converted the number format in excel to text format using this formula:

TEXT(A1,"#.######################") then save as CSV. Then all things are

working now. Thanks again Yaw Anokwa for your help.