Round given number to 0.05

[Former Member]

Hi,

My requirement is to round up the values in a column of a grid to the nearest .05.

The format(values,format) function of BLS doesnt work here. It is rounding the value to nearest 0.0 and adding 0.05 to that value. Same thing happens if I set format to 0.05 in Display Templates.

I tried to manipulate the columns through Javascript but it the values are not always valid.

Could anyone please guide me through this?

Thanks,

Lavanya

[Former Member · Accepted solution]

Hi, Lavanya:

Try this:

format(round(yournumber * 20.0) / 20.0,"0.00")

- Rick

[Former Member · Accepted solution]

Thank you Rick.

It solved my problem.

Lavanya.