Decimal Places

[ajr117 (Gary Wojtowicz)]

I have this expression in a SSRS report

=FormatNumber(Fields!Calc_UnitPrice.Value,Fields!CurrencyCode_DecimalsPrice.
Value)

it returns a currency price with five decimal places, I would like it to
return the price with 2 decimal places.

what do I have to change in this expression to make that happen

I have already tried working with the textbox properties with no luck.

Gary Wojtowicz

AJR Industries, Inc.

[pmarques (Pedro Marques)]

@ajr117

=FormatNumber(Fields!Calc_UnitPrice.Value,Fields!CurrencyCode_DecimalsPrice.

Value)

Try:

=FormatNumber(Fields!Calc_UnitPrice.Value,2)

[BoostERP (Brad Boes)]

Can you change the Fields!CurrencyCode_DecimalsPrice.Value portion of the expression to 2?

Brad Boes
bradboes@boosterpconsulting.com
231-845-1090

[feras23 (Fernando Perez)]

pmarques approach is correct. Another way of doing this is removing formatnumber on the formula, like this:
=Fields!Calc_UnitPrice.Value
and modify the textbox properties.

[ajr117 (Gary Wojtowicz)]

Thanks, that worked