I have a calculated field that is linked to a display map. if the value range from 1-40 it displays green, if the value range from 41-80 it displays yellow, if the value range from 81-100 it displays red.
I'm writing a jaspersoft report and I want to be able to filter on that lookup (green, yellow, red)
how do i write my sql statement to accept the range?
Any ideas?