Beast mode calculation for aggregating data
I have a numeric field called "days until due" which contains negative numbers for outstanding items from -1 to -100. I am trying to group these using a beast mode calc. but keep getting syntax errors. For example, when "days until due" is from -1 to -9 days I want it to be grouped as "1-9 days", -10 to -19 days would be "10 to 19 days". The idea is to group these and sum the value for the range and chart it.
Can anyone please suggest a beast mode calc. that works?