CASE Only works on text fields
I'm trying to create a new calculated field using CASE to segment sessions with continuous file sizes to size buckets (e.g. for each session, was the download for 100-500KB or 1-10MB, and so on).
When trying to create a new calculated field with case on any text field, than the function works, but when trying to do so on any numeric field i get an "Invalid Formula" error.
This is a CASE I've tried applying (tried it with other numeric fields, non worked):
CASE WHEN Downloads (GB)<1 THEN '<1G' ELSE 'OTHER' END
Thanks in advance for any help!