ReportBuilder Miscellaneous
From Team Developer SqlWindows Wiki
Revision as of 23:47, 6 July 2009 by SteveLeighton (Talk | contribs)
This page covers miscellaneous ReportBuilder tips & tricks.
Contents |
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)
