I have time variable. It goes from 0-23. I want to parse it into categories. If 22,23, 0, 1,2 ,3 than 1, If 4,5,6,7,8,9 than 2, if 10,11,12,13,14,15 than 3 if 16,17,18,19,20,21 than 4.
I have trouble writing forumlas with multiple posible outputs. Any advice would be great.
Solved! Go to Solution.
Hi,
The formula should look something like this:
IF [variable] IN (22,23,0,1,2,3) THEN 1
ELSEIF [variable] IN (4,5,6,7,8,9) THEN 2
ELSEIF [variable] IN (10,11,12,13,14,15) THEN 3
ELSEIF [variable] IN (16,17,18,19,20,21) THEN 3
ELSE 0
ENDIF
I have also attached a example workflow.
Have a nice weekend,
Daniel