Method Community

 

Report Designer - Formatting a Money field

Last post 11-20-2013 10:09 AM by Method_Jason. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 11-20-2013 10:09 AM

    Report Designer - Formatting a Money field

    A user asked how to change the amount of decimals showing on a Money field from two to three on a report. 

    Rich,

    Click here for an article about the Report Designer that has the link to download it and also some tutorial videos of how to use it. When you are editing your report, best practice is to edit a copy of the original so that if you make undesirable changes you can revert back. 

    To change the number of decimal places, click the Money field (in your case your Unit Margin field), and then click the white arrow to edit it. You'll want to edit the Format String. Enter this into the field: {0:$0.000}

    See my screenshot below.

    Hope this helps!

    Jason


    Need more help? Ask us about Method consulting services

    Jason Masina
    Community Support Specialist
    Method Integration Inc.
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400
    Fax: 416.640.6027
    E-mail: j.masina@methodintegration.com
Page 1 of 1 (1 items)