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 4: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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article