Round Function

[Dinesh]

Hi,

I there any possibility how to use function Round in report designer for rounding decimal on midpoint?

Now: Round(65427.1315036092,2) = 65427.13
I want Result: Round(65427.1315036092,2) = 65427.14

Thank you.

[Lech Kulikowski]

Hello,

You can use the Ceiling function:
{Ceiling(65427.1315036092*100)/100}

Thank you.

[Dinesh]

Hi,

Thanks for your response. It's working fine.

Thank you.

[Lech Kulikowski]

Hello,

You are welcome.