Forum Discussion
ChayceDuncan
2 years agoQrew Captain
You'll need to use more basic if syntax, Case statement evaluate for exact comparators so better served for conditions like multiple choice fields or option sets that are fixed. In your case - you would do an if statement like:
If(
[Age]<=12, "Child",
[Age]<=19, "Teen",
[Age]<=21, "Young Adult",
"Adult")
------------------------------
Chayce Duncan
------------------------------
MiguelFrancis3
2 years agoQrew Member
Thanks! That worked perfectly!!!!
Regards!
------------------------------
Miguel Francis
------------------------------