Round Up Calculated Field or Format Expression in Report Builder 3.0
Posted on 2014-02-06
I'm attempting to use the DateDiff function to identify the number of minutes between two date time fields. I need it round up to the next whole number.
My formula to count the number of minutes is as follows
The formula is working fine and resulting the correct number of minutes, but my problem is the rounding. If the duration is 1.1 minutes, then I need it to round up to 2. The basic rounding available in Report Builder 3.0 rounds in the traditional .01 t .49 down and .5 to .99 up.
Any suggestions would be greatly appreciated. I'm looking for a calculated field or a format expression type of solution.