Unanswered: absolute deviation by group in crystal
I need an expert.
I have the following data and I need to find the absolute deviation from the median ratio
Specifically, the median ratio for group 101 is 0.8845. I want to take each record field and subtract the median ratio (abs(0.933 - 0.8845)). I can use a running total to calculate the median ratio, but I can't figure out how to subtract the total from each record. Been round and round, even trying to pass the value in from a subreport, but have not had any luck.