Hello,
Wantedto set aging bracket for the attached data.
0-45-1415-3031 Above
Perhaps your [Age] field is being stored as a string rather than numeric. Could you try:
IF ToNumber([Age]) <= 4 THEN '0-4'ELSEIF ToNumber([Age]) <= 14 THEN '5-14'ELSEIF ToNumber([Age]) <= 30 THEN '15-30'ELSE '31 Above'ENDIF
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
Hi @Devika,
This can be completed with a simple formula:
If [Age] <= 4 THEN '0-4'ELSEIF [Age] <= 14 THEN '5-14'ELSEIF [Age] <= 30 THEN '15-30'ELSE '31 Above'ENDIF
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Hello Jonathan,
i tired using the same formula that you mentioned but the third line of the formula is not getting accepted.
once i select the Third AGE then the whole formula gets invalid
