Mackbear
Registered User.
- Local time
- Today, 01:33
- Joined
- Apr 2, 2019
- Messages
- 168
Hello, good day! Reaching out again for help. I can't seem to make this expression work properly. What I need is if the value of the field is:
<-2 "Emergency"
-1 or 0 "Critical"
1 "High"
2 or 3 "Medium"
>3 "Low"
The expression I have is:
IIf([Age]<=-2,"Emergency",IIf([Age]=-1<=0,"Critical",IIf([Age]=1,"High",IIf([Age]>=2<=3,"Medium",IIf([Age]>3,"Low","No Date")))))
The results only show emergency and critical even with values 1 and above.
What am I missing here?
<-2 "Emergency"
-1 or 0 "Critical"
1 "High"
2 or 3 "Medium"
>3 "Low"
The expression I have is:
IIf([Age]<=-2,"Emergency",IIf([Age]=-1<=0,"Critical",IIf([Age]=1,"High",IIf([Age]>=2<=3,"Medium",IIf([Age]>3,"Low","No Date")))))
The results only show emergency and critical even with values 1 and above.
What am I missing here?