Formatting currency problem RRS feed

  • Question

  • User-501297529 posted

    Currently I'm formatting the current on a field and when I look at the report the amounts that have an actual cent ex. 449.91 they show on the report as 449.91 but the amounts that don't have a cent ex. $1369.00 it shows on the report as $1369. Can someone help me to figure out a way so that when an amount that has .00 to show on the report as 1369.00 instead of 1369.  THis is what I have for the expression:

    =Format(Round(Fields!TcAmtTemp.Value, Fields!CurrencyPlaces.Value), Fields!CurrencyFormat.Value)

    and I have N2 for the Custom format.

    Friday, November 16, 2012 5:02 PM


All replies