custom layout designer - decimals

Question

I would like to only have two decimals after the point please for the Quantity field and Unit Price - what are the properties for this to be achieved please

Stacy_K · Accepted Answer

Hi there Chipping in to help here, or you may wait some time for support: 1. In Report Layout Designer select the [Quantity] field you want to change the properties for. Make sure you select the field under "Detail" section on your report, and not the heading 2. Within the Property Grid on the right, scroll down to Data > Data Bindings > Text > Format String and select the 3 dots (...) on the right of "Format String" 3. Select your desired format. If you are looking for 2 decimal places then you should select #.00 under "Number" format 4. In the Properties Grid next to Format String it should now show {0:#.00} For the [Unit Pricing] , follow the above steps but: 3. Select the format c under "Currency" format 4. In the Properties Grid next to Format String it should now show {0:c} Let me know if that doesn't work.

Sage Accounting

custom layout designer - decimals

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING