Using multiple pulldata functions in a calculate field

783
5
Jump to solution
03-29-2018 03:18 PM
JohnMarra
New Contributor III

I can't seem to get the calculation to work correctly when I use multiple pulldata functions. For example.

3 * pulldata('tubing', 'vol', 'dia', ${field_7}) * ${field_19})

works fine, but 

3 * pulldata('tubing', 'vol', 'dia', ${field_7}) * ${field_19}) + pulldata('flow', 'vol', 'size', ${field_21}

does not work. It gives me no answer at all. 

EDIT: As a workaround, I can assign the 2nd pulldata function to a decimal field and use the decimal field in the place of the 2nd pull data function. I just don't want to have to see the decimal field in the survey.

0 Kudos
1 Solution

Accepted Solutions
SMauri
by
Occasional Contributor III

I will try something like this...

typenamecalculation
calculationquestion1pulldata('tubing', 'vol', 'dia', ${field_7})
calculationquestion2pulldata('flow', 'vol', 'size', ${field_21}
calculationquestion33 * ${question1} * ${field_19}) + ${question2}

Cheers

Stefano

View solution in original post

0 Kudos
5 Replies
SMauri
by
Occasional Contributor III

I will try something like this...

typenamecalculation
calculationquestion1pulldata('tubing', 'vol', 'dia', ${field_7})
calculationquestion2pulldata('flow', 'vol', 'size', ${field_21}
calculationquestion33 * ${question1} * ${field_19}) + ${question2}

Cheers

Stefano

0 Kudos
JohnMarra
New Contributor III

Got it. That makes sense. Thank you.

0 Kudos
SMauri
by
Occasional Contributor III

Risultati immagini per ok

...and don't forget to mark question as solved

0 Kudos
JohnMarra
New Contributor III

This solution no longer works in version 2.7.72???

What is up with this update?

0 Kudos
JamesTedrick
Esri Esteemed Contributor

Hi John,

I do not believe that the issue you are experiencing is 2.7 specific.  The XLSform translator (the software that translates the XLS file to the form XML file), does not recognize pulldata functions when they do not begin a line - the procedure you mentioned (dedicating a line to receive a pulldata value, then using it in a calculation) is the preferred form authoring pattern.

0 Kudos