ReportBuilder Miscellaneous

From TeamDeveloperWiki

This page covers miscellaneous ReportBuilder tips & tricks.

Contents 1 ReportWindows RoundUp formula

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)