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
Solved! Go to 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
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?
Hi @timl thanks for the reply. I just checked and it is, could there be another reason it's not showing up?
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