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)

Suggested answer

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

Like (0)

Report

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
Verified answer

ShanAbeywicrema 948 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Alexander Ermakov 28,096 on at

Like (0)

Report

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

Was this reply helpful? Yes No