Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Rounding up numbers on Y Axis to nearest multiplier of 100
kiranv
Hello All,
I want to (rather my client wants to ^_^ ) see the numbers on the Y-Axis rounded off to the nearest multiplier of 100. Kindly check the attachment.
The Y-Axis reads 731,1461,2192,2922,3653. So my client wants it be rounded off to the nearest multiplier of 100 say it should be 700,1500,2200,2900,3600.
Kindly suggest how to do it in BIRT Reports. It is basically generated from a J2EE web app so i am fine changing it thru code.
Find more posts tagged with
Comments
mwilliams
Hi kiranv,
Are these summed group values? Or the actual values from your dataSet? If they're straight from your dataSet, you should be able to just create a computed column that rounds to the nearest 100 and use this field in your chart. If it's a summation of values from your dataSet in a group, there will be a little more work involved. Let me know.