Rounding a value to nearest 10 in Report Builder

(0) Share

Report

Posted on by Magiltharan

Hi,

Is there any method to rounding a value to nearest 10 in Report Builder? For an example: if the value is 46, it has to be rounded to 50. If the value is 43, it has to be rounded to 40.

Thanks

Magil

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Round("YourValue" / 10) * 10

Maby there is a better way, but it works.

Obelix

Was this reply helpful? Yes No
Binesh 7,887 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Use below function:

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Hello Ninesh,

your solution is ok.

But the question from Magiltharan was

a solution in Report Builder and not in Navision.

Obelix

Was this reply helpful? Yes No
Verified answer

Binesh 7,887 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Magiltharan 55 on at

Like (0)

Report
Copy link

Link copied!

Hi. Thanks for the time. I need in Report Builder. Binesh's solution working perfectly. Cheers

Was this reply helpful? Yes No
Magiltharan 55 on at

Like (0)

Report
Copy link

Link copied!

Hi Binesh. Thanks for the time. It worked perfectly fine. Cheers.

Was this reply helpful? Yes No