Logic references error calculatin zscore

Hie guys,

I'm getting the followin error:

calculation Error: Error in calculation for /data/Nutriton_Statistics/score
Logic references Height which is not a valid question or value. You may
have forgotten to include the full pathe to the question e. /data/Height).
(Expanded reference: instance(zscores-2to5yrs)/zscore_list/zsore[1]/Height)

I followed the instructions on creating and calculating zscores and changed
the field called 'month' in the help site guide to 'Height', and uploaded
the appropriate values.

I'm thinking I may have missed somethin.

Can someone please help me so I go past this error and calculate the
zscores correctly

Thanks

Eva

Hi Eva,

I noticed that in the expanded reference you posted:

instance(zscores-2to5yrs)/zscore_list/zsore[1]/Height

There appears to be a typo, 'zsore' presumably instead of 'zscore'. This
could cause the error message that you're seeing.

Another possibility is that when you renamed 'month' to 'Height' in the
lookup table xlsx file not all occurrence were renamed, so the node named
"Height" isn't found.

Cheers,
Will

··· On Fri, Sep 22, 2017 at 8:17 PM, Eva wrote:

Hie guys,

I'm getting the followin error:

calculation Error: Error in calculation for /data/Nutriton_Statistics/
score
Logic references Height which is not a valid question or value. You may
have forgotten to include the full pathe to the question e. /data/Height).
(Expanded reference: instance(zscores-2to5yrs)/
zscore_list/zsore[1]/Height)

I followed the instructions on creating and calculating zscores and
changed the field called 'month' in the help site guide to 'Height', and
uploaded the appropriate values.

I'm thinking I may have missed somethin.

Can someone please help me so I go past this error and calculate the
zscores correctly

Thanks

Eva

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hie Will,

Thanks for the response.

The typo is actually my typo error posting this issue.

But I'm thinkin you may be right about not all occurrencencies bein updated.

If you could point me in the riht direction and advise where I can find
these nodes.

Also, I was wonderin, when i download lookup tables if i change the name
that is automatically given to xls file does this affect my referencing
when i upload the updated files with a different name?

If you have time to spare maybe u could meet me on skype for a more
interactive assistance.

Thanks...

Eva

··· On Monday, September 25, 2017 at 7:13:08 PM UTC+2, William Pride wrote: > > Hi Eva, > > I noticed that in the expanded reference you posted: > > instance(zscores-2to5yrs)/zscore_list/*zsore*[1]/Height > > There appears to be a typo, 'zsore' presumably instead of 'zscore'. This > could cause the error message that you're seeing. > > Another possibility is that when you renamed 'month' to 'Height' in the > lookup table xlsx file not all occurrence were renamed, so the node named > "Height" isn't found. > > Cheers, > Will > > On Fri, Sep 22, 2017 at 8:17 PM, Eva <eva.t...@gmail.com > wrote: > >> Hie guys, >> >> I'm getting the followin error: >> >> calculation Error: Error in calculation for >> /data/Nutriton_Statistics/score >> Logic references Height which is not a valid question or value. You may >> have forgotten to include the full pathe to the question e. /data/Height). >> (Expanded reference: instance(zscores-2to5yrs)/zscore_list/zsore[1]/Height) >> >> I followed the instructions on creating and calculating zscores and >> changed the field called 'month' in the help site guide to 'Height', and >> uploaded the appropriate values. >> >> I'm thinking I may have missed somethin. >> >> Can someone please help me so I go past this error and calculate the >> zscores correctly >> >> >> Thanks >> >> Eva >> >> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Hi Eva,

The structure of the lookup table excel spreadsheet is described here
https://confluence.dimagi.com/display/commcarepublic/Creating+and+Updating+Lookup+Tables.
Essentially you'd want to just find and replace all occurrences of "month"
in that document with "height" to ensure that you updated this correctly.

As to the file name, I'm not sure whether changing this would have
unintended consequences, but I'd recommend just keeping it the same to
avoid any issues.

Cheers,
Will

··· On Mon, Sep 25, 2017 at 4:10 PM, Eva wrote:

Hie Will,

Thanks for the response.

The typo is actually my typo error posting this issue.

But I'm thinkin you may be right about not all occurrencencies bein
updated.

If you could point me in the riht direction and advise where I can find
these nodes.

Also, I was wonderin, when i download lookup tables if i change the name
that is automatically given to xls file does this affect my referencing
when i upload the updated files with a different name?

If you have time to spare maybe u could meet me on skype for a more
interactive assistance.

Thanks...

Eva

On Monday, September 25, 2017 at 7:13:08 PM UTC+2, William Pride wrote:

Hi Eva,

I noticed that in the expanded reference you posted:

instance(zscores-2to5yrs)/zscore_list/zsore[1]/Height

There appears to be a typo, 'zsore' presumably instead of 'zscore'. This
could cause the error message that you're seeing.

Another possibility is that when you renamed 'month' to 'Height' in the
lookup table xlsx file not all occurrence were renamed, so the node named
"Height" isn't found.

Cheers,
Will

On Fri, Sep 22, 2017 at 8:17 PM, Eva eva.t...@gmail.com wrote:

Hie guys,

I'm getting the followin error:

calculation Error: Error in calculation for
/data/Nutriton_Statistics/score
Logic references Height which is not a valid question or value. You may
have forgotten to include the full pathe to the question e. /data/Height).
(Expanded reference: instance(zscores-2to5yrs)/zsco
re_list/zsore[1]/Height)

I followed the instructions on creating and calculating zscores and
changed the field called 'month' in the help site guide to 'Height', and
uploaded the appropriate values.

I'm thinking I may have missed somethin.

Can someone please help me so I go past this error and calculate the
zscores correctly

Thanks

Eva

--
You received this message because you are subscribed to the Google
Groups "commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.