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

Created by Hazel Ng, Modified on Fri, 17 Mar 2023 at 04:14 PM by Shirley Choong

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 :) 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article