nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Adding integers for a select One from list type question giving error

RachelS

Hi,

I have 6 select from one list type question where the possible answer is +1 or -1. I then want to add the answers from these. But rather than adding the integers in a calculation it just adds a 1 into the sum box. e.g. -1111.

If I try setting the bindType field to Int then it says Error converting XLS form.

I'd appreciate any help.

Thanks

Rachel

macro test.xlsx

Encontre mais publicações marcadas com

Accepted answers

MobiusSnake

From what I can see, it looks like issues will occur if any of the questions aren't completed, but as long as all six questions are completed, the value comes out okay. One option would be to change your calculation to this:

number(${stonefly1})+number(${mayfly1})+number(${caddisfly1})+number(${snail1})+number(${leech1})+number(${waterlouse1})

This will result in the calculation failing (and showing nothing) until all six questions are completed, since the number() function will fail on missing values.

If these questions are all mandatory that should work, if they're optional then I think you'll need to include some if() functions.

All comments

RachelS

Hi @MobiusSnake ,

Thanks for that, I'm just going to force the user to complete all the questions.

Regards

Rachel

MobiusSnake

number(${stonefly1})+number(${mayfly1})+number(${caddisfly1})+number(${snail1})+number(${leech1})+number(${waterlouse1})

This will result in the calculation failing (and showing nothing) until all six questions are completed, since the number() function will fail on missing values.

If these questions are all mandatory that should work, if they're optional then I think you'll need to include some if() functions.

PanGIS

Hi @RachelS

I noticed the missing dollars and I added myself.

the calculation works for me, I just added the dollars.

( I have forgotten to upgrade 😅 and I am using connect 3.16.110)

RachelS

Ah thanks @MobiusSnake , I'd updated the dollar signs but didn't update the xls sheet.

I've attached the xls with the updates you mentioned but the calculation still doesn't work for me.

I'm on version 3.18.123.

Here's what I get below.

macro test.xlsx

MobiusSnake

Your calculate line is missing a few dollar signs. You've got them for the first couple variables but they're missing after that. I just tried bringing your XLSX into S123 Connect, set the binding on that last question to Integer and inserted the dollar signs and it looks all good.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.