Hi there,
I am trying to add a conditional statement in my report so that I can get color coded risk score.
In my survey Risk Score is calculated on a risk probability and impact (various parameters).
e.g. flood probability - alright
flood impact - severe
Risk score - Extreme
I am struggling to get the query correct as I am having various parameters for which risk been calculated.
if(${flooding_risk== 'Almost_certain' }and ${flooding_impact== 'Severe'},)Extreme (25)
if(${flooding_risk}== 'Likely' and ${flooding_impact}== 'Severe',)Extreme (20)
result it is showing
![AnuSawant_1-1652925530776.png AnuSawant_1-1652925530776.png](https://community.esri.com/t5/image/serverpage/image-id/41688iBECE3E776EF89A92/image-size/medium?v=v2&px=400)
I am expecting my result should print only "Extreme (25)" or "Extreme (20)" if its present in the record.
Any help would be appreciated.
Thanks,
Anu