Rounding decimal variable to 2 decimal places

(0) Share

Report

Posted on by Community Member

Hi,

This should be very easy to do but I must be doing something wrong.

I have a decimal variable called 'RemainingAmt'. I want to round this to 2 decimal places, so I make the change in the variables properties. But it still shows 123.45678 instead of 123.46.

What am I doing wrong?

0434.Capture4.PNG

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: Rounding decimal variable to 2 decimal places

msdn.microsoft.com/.../dd301418.aspx

Was this reply helpful? Yes No
Verified answer

ShanAbeywicrema 948 on at

Like (0)

Report

RE: Rounding decimal variable to 2 decimal places

You can use ROUND function and it is more easy to handle.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,021 Super User 2025 Season 2 on at

Like (0)

Report

RE: Rounding decimal variable to 2 decimal places

You could use the format function to convert the value, something like below

FORMAT(TotalAmount,0,'<Precision,2:2><Sign><Integer Thousand><Decimals>')

Was this reply helpful? Yes No