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)