Rounding decimal variable to 2 decimal places

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

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

ShanAbeywicrema 942 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.
Suggested answer

Suresh Kulla 44,656 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>')