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

Hi,

Round("YourValue" / 10) * 10

Maby there is a better way, but it works.

Obelix

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

Like (0)

Report

Hello,

Use below function:

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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,885 on at

Like (1)

Report

Was this reply helpful? Yes No
Magiltharan 55 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No