How to compare 2 calculated values

Support
1

Hi All

Please can you help me to resolve this issue.
Please find attached an example.
I want to compare the "Total area" with "parcel area calc" without changing the order of questions!
if they are not equal we should not pass to the next step.
Any help? Thank you

Med Helmi

Sum_test.xls (58 KB)

2

Any help please? It's URGENT
Thanks

··· Le jeudi 2 juin 2016 13:29:58 UTC+1, AMH a écrit : > > Hi All > > Please can you help me to resolve this issue. > Please find attached an example. > I want to compare the "Total area" with "parcel area calc" without > changing the order of questions! > if they are not equal we should not pass to the next step. > Any help? Thank you > > Med Helmi
3

This may be a limitation of the XLSForm converter.

The problem seems to be that the total_feld_calc field is stored as a
"string" field, so the subsequent sum(${total_field_calc}) will fail with a
type conversion failure.

If you hand-edit the XML file and change total_field_calc's data type to
"decimal", it should work.

(the data type is specified in the statement for the that field ).

See https://opendatakit.org/help/form-design/ for an explanation of the XML
file structure.

··· On Thu, Jun 2, 2016 at 8:31 AM, AMH wrote:

Any help please? It's URGENT
Thanks

Le jeudi 2 juin 2016 13:29:58 UTC+1, AMH a écrit :

Hi All

Please can you help me to resolve this issue.
Please find attached an example.
I want to compare the "Total area" with "parcel area calc" without
changing the order of questions!
if they are not equal we should not pass to the next step.
Any help? Thank you

Med Helmi

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com

4

I have a repeat group where I take Cultivated Area for each field and do
the Sum.
What I want to do is that the sum in repeat should be equal to the total
Area I had before the repeat group.

Thank you!

Sum_test.xls (58 KB)

··· Le lundi 6 juin 2016 21:43:20 UTC+1, Mitch Sundt a écrit : > > This may be a limitation of the XLSForm converter. > > The problem seems to be that the total_feld_calc field is stored as a > "string" field, so the subsequent sum(${total_field_calc}) will fail with a > type conversion failure. > > If you hand-edit the XML file and change total_field_calc's data type to > "decimal", it should work. > > (the data type is specified in the statement for the that field ). > > See https://opendatakit.org/help/form-design/ for an explanation of the > XML file structure. > > > On Thu, Jun 2, 2016 at 8:31 AM, AMH <moh...@6grain.com > wrote: > >> Any help please? It's URGENT >> Thanks >> >> >> Le jeudi 2 juin 2016 13:29:58 UTC+1, AMH a écrit : >>> >>> Hi All >>> >>> Please can you help me to resolve this issue. >>> Please find attached an example. >>> I want to compare the "Total area" with "parcel area calc" without >>> changing the order of questions! >>> if they are not equal we should not pass to the next step. >>> Any help? Thank you >>> >>> Med Helmi >> >> -- >> -- >> 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. >> > > > > -- > Mitch Sundt > Software Engineer > University of Washington > mitche...@gmail.com >
5

Filed as an issue at https://github.com/XLSForm/pyxform/issues/70

Yaw

··· -- Need ODK consultants? Nafundi provides form design, server setup, in-field training, and software development for ODK. Go to https://nafundi.com to get started.

On Thu, Jun 16, 2016 at 2:18 PM, AMH mohamed@6grain.com wrote:

I have a repeat group where I take Cultivated Area for each field and do the
Sum.
What I want to do is that the sum in repeat should be equal to the total
Area I had before the repeat group.

Thank you!

Le lundi 6 juin 2016 21:43:20 UTC+1, Mitch Sundt a écrit :

This may be a limitation of the XLSForm converter.

The problem seems to be that the total_feld_calc field is stored as a
"string" field, so the subsequent sum(${total_field_calc}) will fail with a
type conversion failure.

If you hand-edit the XML file and change total_field_calc's data type to
"decimal", it should work.

(the data type is specified in the statement for the that field ).

See https://opendatakit.org/help/form-design/ for an explanation of the
XML file structure.

On Thu, Jun 2, 2016 at 8:31 AM, AMH moh...@6grain.com wrote:

Any help please? It's URGENT
Thanks

Le jeudi 2 juin 2016 13:29:58 UTC+1, AMH a écrit :

Hi All

Please can you help me to resolve this issue.
Please find attached an example.
I want to compare the "Total area" with "parcel area calc" without
changing the order of questions!
if they are not equal we should not pass to the next step.
Any help? Thank you

Med Helmi

--

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.

--
Mitch Sundt
Software Engineer
University of Washington
mitche...@gmail.com

--

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.