Round or change format for report for one column only

Question

I created a report that works great.

Does anybody know how to format this properly without changing the rest of the columns? See red box. The answer should be 0.01.

I changed the format to decimal but it changes all the columns and I need the other columns to be whole numbers and the Amount OB column to be able to have decimals.

Data

Did you check this [thread](http://stackoverflow.com/questions/26892564/ssrs-format-to-display-as-percent?rq=1) if it resolves your concern? — Techie, Jul 16 '15 at 17:58

score 0 · Answer 1 · answered Jul 16 '15 at 18:55

0

You can do this numerous ways with an RDL. One way is to set the text box properties, on the Number tab. Or you could do this in the expression of the value like so:

=FormatNumber(Fields!Weight.Value,2)

enter image description here

If you need to round the number you can also do that in the expression like so:

=Round(Fields!Weight.Value,2)

answered Jul 16 '15 at 18:55

Mike

550
2
16

Like I mentioned above this changes every column. I only need the first column changed. – Apollo Jul 16 '15 at 19:54
Changing a single text box property on a single cell does not change an entire column or row. You can however Round to two digits every time for that cell as well without affecting anything else. – Mike Jul 16 '15 at 20:17

score 0 · Answer 2 · answered Jul 16 '15 at 20:29

After spending hours figuring this out. I got the solution. I added the following expression in the total box for the Amount OB column.

=iif(Fields!MeasureDesc.Value= "Amount OB",
Format(SUM(Fields!MeasureCount.Value),"N2"), SUM(Fields!MeasureCount.Value))

This reads if the column equals Amount OB then use two decimal places else just sum the MeasureCount. MeasureCount are the cells that are under Amount OB.

Round or change format for report for one column only

2 Answers2