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; } } }

Can you see results of Calculate field or help with a secondary calcuation

RachaelMurtaugh

I'm making a survey where I have a few calculate fields, but I'd like to be able to see those fields or see a final result. I have the sum of the numbers of different invertebrates found in a stream which then coordinate to an index rating(Excellent, Good, Fair, Poor). I want the sum to be an automatic calculation. Then I either need the output to be visible so they can select the index rating or have it automatically calculate the final index based on the value ( >22 Excellent, 17-22 Good, 11-16 Fair,<11 Poor). I can't seem to get the calculate field properly written to automatically rate based on the index sum. My IF statements aren't working.

Encontre mais publicações marcadas com

Accepted answers

JA7

Without seeing your XLS we can't help you with your If statements. I would change your question type from calculation to text or integer (depending on your data). That way you can see what value your calculation is returning. Once it is working, you can change it back to a calculate question, or change the appearance to hidden (if you want to record the calculated value in your data).

All comments

JA7

RachaelMurtaugh

I didn't realize you could put in a calculation and not have it be a calculate field type. Thanks! Keeping it as an integer is perfect.

JA7

The calculation question type ensures that it is hidden and not recorded in your data. Which is useful if you're using that calculation to drive something else in your survey but the value in and of itself isn't needed.

Calculations can be applied to a variety of question types, but by default are not hidden and are recorded in your data. This is useful if you want users to see the calculation value or record the calculation in your data. It is also helpful when troubleshooting why your calculate question isn't working as expected. You can force these question types to be hidden and/or not recorded using the hidden appearance and the null fieldtype.

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.