How to set report format to show 0.00 when the unit price is blank? : QNE Software Sdn. Bhd.

How to display 0.00 or Blank in report format when the item do not have unit price? Print

Created by: Hazel Ng

Modified on: Fri, 17 Mar, 2023 at 4:14 PM

Scenario 1:

How to set report format to show 0.00 when the unit price is blank?

Refer the below transaction_

1. Go to Task > Design > click on the field that you want to show 0.00

2. Click on the small arrow [>]

3. Edit the Format String to {0:#,#0.00;;"0.00"}

4. Save and Preview

Scenario 2:

How to display Unit Price column as blank in Report Format for item that do not have Unit Price?

For below transaction:

1. Repeat Step 1 - 2 above

2. Edit the Format String to {0:#,#0.00;;""} > Save

3. Preview the new report format

Thank you :)

Hazel is the author of this solution article.

Did you find it helpful? Yes No

How to display 0.00 or Blank in report format when the item do not have unit price? Print