Beast mode calculation for aggregating data
Hi, 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…