Custom number format rounding

[Peter23]

Hi there, I have the requirement to “round” numbers, e.g. 0.365 to 36, so that, the number * 100 and rounding without decimal number.
0.365 * 100 = 36.5 = 36

So I apply custom format to measure (#,###[%]), but it returns 37 (0.365) so It’ś mean wrong, is there any function to custom the interval to return, e.g < 0.005 = 0.00 and > 0.006 = 0.01 the rounding interval.

In excel it has a ROUNDDOWN function any similar in webi or workaround?

[FrustratedScot]

Have a look at floor

[MarkP]

As @FrustratedScot says, floor is your friend.

=Floor([Measure]*100)/100

Then you can format that as a percentage.

[davids]

Use

Ceil : This rounds up a number
Floor : This rounds down a number