Use conditional logic to place a literal value to each range, an example being:
if (field) in [1 to 7] then "Low" else
if (field) in [8 to 12] then "Med" else
This formula will be allowed by Crystal because a literal value is the final output.
grouping, range , KBA , BI , Business intelligence solutions , How To