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

Formula

DrJumaKhudonazarov

Can someone please please advise if the bellow formula is correct?

if(${CF_Rating}='192',high risk}if(${CF_Rating}='130',medium risk}if(${CF_Rating}='120',low risk}

I want to use rating score and if I enter 192 cm in previous question the next note should appear ''HIGH RISK"

Trouver plus de publications taguées avec

Accepted answers

Richard_Purkis

Hi @DrJumaKhudonazarov

Without your form it is hard to be sure why your formula isn't working. A good recommendation to start is to chain your if statements together.

Each if statement is the 'else' choice for the proceeding if statement until you arrive at the end. That is where you then add the default option if none of your if statements are true. For example:

if(${CF_Rating}='192', 'high risk', if(${CF_Rating}='130', 'medium risk', if(${CF_Rating}='120', 'low risk', '0')))

Hope this helps

All comments

DrJumaKhudonazarov

I have sent you a direct message with an attachment please have a look when you have chance

Richard_Purkis

@DrJumaKhudonazarov

You can attach it to your comment or send it to me in a Direct Message.

Thanks

DrJumaKhudonazarov

I am getting this message

DrJumaKhudonazarov

Dear Richard

Thanks. How I can share my form with you ? Can I send it by email ?

Richard_Purkis

Hi @DrJumaKhudonazarov

Without your form it is hard to be sure why your formula isn't working. A good recommendation to start is to chain your if statements together.

Each if statement is the 'else' choice for the proceeding if statement until you arrive at the end. That is where you then add the default option if none of your if statements are true. For example:

if(${CF_Rating}='192', 'high risk', if(${CF_Rating}='130', 'medium risk', if(${CF_Rating}='120', 'low risk', '0')))

Hope this helps

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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