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
Feedback sent
We appreciate your effort and will try to fix the article