Page 1 of 1

Round Function

Posted: Wed Aug 03, 2022 11:48 pm
by 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.

Re: Round Function

Posted: Thu Aug 04, 2022 6:39 am
by Lech Kulikowski
Hello,

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

Thank you.

Re: Round Function

Posted: Thu Aug 04, 2022 11:28 pm
by Dinesh
Hi,

Thanks for your response. It's working fine.

Thank you.

Re: Round Function

Posted: Fri Aug 05, 2022 9:59 am
by Lech Kulikowski
Hello,

You are welcome.