I tried doing that, formatting the value with n2 it rounds to .41 at the end of the sum..

Is there any way to find the decimal point in Expression and...

Thank you very much for your responses

As i did in Stored procedure is there any way to trim the value to last 2 decimal points in SSRS 2005 reports.

if for...

Hi Madhu,

When my value is like 1567987.4699987 i got the output as

1567987.47 which is actually rounding off the value

DECLARE @Num4 AS DECIMAL(10,4)

SET @Num4 = 1567987.4699987

SELECT LEFT(CONVERT(VARCHAR(20),@Num4),CHARINDEX('.',CONVERT(VARCHAR(20),@Num4))+2)

And the values...

Hi,

I want to trim the value of decimal point to 2.

For example

1245.658797

123597.599945

798754.589785

787561.124657

I want this to be displayed as

1245.65

123597.59

798754.58

787561.12

If i try to use decimal(15,2) it will round off the value.

If i...