Fractional as 1/2 , 1/4 etc. or rounded somehow?
I wish to display theses numbers as 32's rounding to the nearest
You could create a calculation to do that. Here I've broken it down into multiple parts, but you could have one calc
A calc [Value Agg] that is the aggregation you are using for your bars - e.g. sum([sales])
And the actual string to put on the label shelf
if int([Value Agg])<>0 then str(int([Value Agg]))+" " else "" end +
str(round(([Value Agg]-int([Value Agg]))*32,0))
This checks to see if the number has an integer component (i.e. we don't want to show 0 12/32), displays the integer if we do, creates another string that has the 32ths (find the decimal part by removing the integer part, multiply by 32, and round), then add the string "/32".
I'm guessing with the way the round goes, you could end up with 3 32/32, so you may want to error check that, but this should give you a start.
32ths.twbx.zip 1.1 MB