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.