Difference between revisions of "ReportBuilder Miscellaneous"
From Team Developer SqlWindows Wiki
| Line 5: | Line 5: | ||
<!------------------------------------------------------------------------------------------------------------------------------> | <!------------------------------------------------------------------------------------------------------------------------------> | ||
| − | {{TipHeader| | + | {{TipHeader|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 | ||
| + | |||
| + | |||
| + | <pre> | ||
| + | NumberIFF( nInput - (NumberTruncate(nInput,0)) , | ||
| + | nInput, | ||
| + | nInput, | ||
| + | (NumberTruncate(nInput,0)) + 1) | ||
| + | </pre> | ||
Revision as of 23:47, 6 July 2009
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)
