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

Alexander Ermakov 28,096 on at

Like (0)

Report

RE: Rounding decimal variable to 2 decimal places

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

Was this reply helpful? Yes No