Hi - I created the a variable (vDayrangecat) with the following calculation :
IF($(vNumberofdays) >= 0 and $(vNumberofdays) <= 3, '0-3',
IF($(vNumberofdays) > 3 and $(vNumberofdays) <= 5, '3+-5',
IF($(vNumberofdays) > 5 and $(vNumberofdays) <= 10, '5+-10',
IF($(vNumberofdays) >= 10, '10+','<0'))))
Therefore, if vNumberofdays for a specific data row = 6, then vDayrangecat = '5+ - 10'
I would like to do a histrogram on the vDayrange but it is not working. Thoughts ? Jerry