Help -: replacing 0 by - in a filed

how can i print "-" in place of zero in below field, so whenever value will be zero it will print dash, currently it is printing 0% if value is nil but i want to print -

Code:

[Field: POS RateofDuty]
   Use       : Number Field
   Set As     : $TVATSTKIVatRate:StockItem:$StockItemName
   Format     : "Zero,Percentage"
   Width     : 20% Page

 

Sir, thanks for the reply, the condition provided by you looks perfect but it's not working please see image -

in first image using old code Tax% is coming

but in 2nd part of image after using below code Tax % is coming only 0%, please help

Code:

[Field: POS RateofDuty]
    Use            : Number Field
    Set As        : if $$IsEmpty:$TVATSTKIVatRate:StockItem:$StockItemName then $$String:"-" Else $TVATSTKIVatRate:StockItem:$StockItemName
    Width        : 20% Page
    Format        : "Zero,Percentage"
    Align        : Center

 

Sir

I tried, i don't know why its not working, can i do something separately to change 0% of this field in to -, please help

 

Thanks for the reply, after removing Use : Number Field, it is working and showing "-" but it's not showing percentage sign (please see image)

this is after using below code

Code:

[Field: POS RateofDuty]
Set As         : If $$IsEmpty:    $TVATSTKIVatRate:StockItem:$StockItemName then $$String:"-" Else $TVATSTKIVatRate:StockItem:$StockItemName 
Width        : 20% Page
Format        : "No Zero, Percentage"
Align        : Center

 

Thanks for the reply, it is showing bad formula error after using this, please see image

 

Dear sir, thanks for the reply

after using this, - sign is coming if field and % sign is also coming but 0% is coming every time even if there is 5%

 

One more option can be add another field with string in nature and use it for printing and make the actual calculation fields invisible