Decimal Places

[laducd]

Hi

I have data with only 2 decimal places however on my report I would like it to display with 3 decimal places. The third decimal place I would like to be 0

[Edward]

Hi Labucd,

Please try the following expression:

Code: Select all

{String.Format("{0:0.000}", DataSourceName.DecimalValueColumn) }

Thank you,
Edward

[laducd]

I am still getting 2. The data is only 2 decimals, I would just like to add the 0

{String.Format("{0:0.000}", cq1.Line_Foreign_Amount) }

[Edward]

Hi Laducd,

It maybe the case when the type of that cq1.Line_Foreign_Amount column is not a numeric/decimal but some other type. That would be an explanation on why that did not work. There is an easy way to check in the designer:

3DecimalPoints.PNG (63.71 KiB) Viewed 4651 times

3DecimalPlaces.mrt

(14.05 KiB) Downloaded 233 times

Thank you,
Edward

[laducd]

Ok I changed it to Decimal format, however I am now getting too many 0.


-12937.5000000000

[laducd]

I figured it out, thanks for your help

[Andrew]

Okay, thank you for letting us know about this.