Scenario
Example:
In Standard format unit price will display blank, If user did not insert any of unit price. Maybe this 2 item are free of charge.
But it also can be customize as above picture, to know how to customize please check solution:
Solution
Step 1 – Open a sample invoice à Click Task.
Step 2 – Click Design.
Step 3 – Once Click Design , report format list will appear, double click any of the invoice format.
Once double click to invoice format, please give a format display name and format code.
Any name and any code.
Step 4 – once go in to the format, Click on unit price, right click the unit price à Click Add calculated field.
Step 5 – once click Add Calculated field à a ‘calculated field 1’ will appear à Right Click it and Click edit calculated field
Step 6 – insert a name, and expression please insert as below:
Iif(IsNullOrEmpty([Unit Price])||[Unit Price]=0,'Free of charge' ,[Unit Price] )
Click OK.
Then Click Save.
Last Check the result.
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