Currently, Amount Fields allow setting only non-zero values.
In order to force zero onto fields bearing empty values, the Type of the Field must be changed to either String or Number optionally (if the value is zero) and Zero can be set in the Field.
If the Field Type is set to Number, the Attribute Format must be set to Zero.
For example ,
Following code sets zero in Debit and Credit Fields that are Empty within the default Trial Balance Report:
[#Field: DSPClDrAmtA]
Option : DSPClDrAmtA Number : $$IsEmpty:@FldValue
[!Field: DSPClDrAmtA Number]
Inactive: No
Type : Number
Format : "Zero"
[#Field: DSPClCrAmtA]
Option : DSPClDrAmtA Number : $$IsEmpty:@FldValue
