From Team Developer SqlWindows Wiki
Revision as of 23:47, 6 July 2009 by SteveLeighton (Talk | contribs)
This page covers miscellaneous ReportBuilder tips & tricks.
ReportWindows RoundUp formula
Returns any decimalised number rounded UP to the nearest whole. UnDecimalised input is returned un-rounded. Allocates no memory for efficiency. eg 2.2 becomes 3, 2.9 becomes 3 , 2 stays as 2
NumberIFF( nInput - (NumberTruncate(nInput,0)) , nInput, nInput, (NumberTruncate(nInput,0)) + 1)