If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Round HalfUp

Started by IndyBob, 18 Nov 2014 08:51:45 AM

Previous topic - Next topic

IndyBob

Is there a function for Round HalfUp in Frameworks Manager? For example, I have a number of months and want to calculate years with 9 months being 0.8 years. So, 9/12.0 = 0.75 and needs to be rounded to 0.8. Apparently the _round function does not respect the half and my function _round(9/12.0, 1) returns 0.7.

bdbits

Why are you using _round() instead of round()?

At any rate, I took your expression and pasted it into a blank query subject, then hit the "Test Sample" toolbar item and it returned the expected 0.8. I am having a hard time coming up with a reason you would get 0.7. Is there a data column involved where you have "9/12.0"? Could there be some extended decimal places involved, but not being seen due to formatting?