Finding fields in a model driven calculated field

[darrenfloyd666]

Morning 

I'm trying to recreate the following formula in a Model Driven calculated field: =IF([Risk Likelihood]="Rare",1,IF([Risk Likelihood]="Unlikely",2,IF([Risk Likelihood]="Possible",3,IF([Risk Likelihood]="Likely",4,IF([Risk Likelihood]="Almost Certain",5,0)))))

I've created a drop down field called Risk Likelihood:

But when I come to find it in the drop down field in the calculation it's not showing (along with a number of other fields).

What am I doing wrong? All help appreciated 

[timl]

Hi @darrenfloyd666 

One reason why fields don't show up is if the 'searchable' option isn't selected for the field in the CDS entity designer. Can you check if [Risk Likelihood] is defined as searchable?

[darrenfloyd666]

Hi @timl thanks for the reply. I just checked and it is, could there be another reason it's not showing up?

[darrenfloyd666 · Accepted solution]

I've found the answer. It's because I set the type up as Multiselect as opposed to Option Type. Thanks for your help @timl