Hi all,
I’m trying to merge a table into my document template but I would like to suppress zero value. So when the value is less than or equal zero the merge region will display nothing. I’ve tried using this switch #
“$,0.00;;” but it still produces ‘0’ not ’ '. Or should I use If condition to format the display? Is it possible using if condition in merge region? Thanks.
Raymon
Hi
Laurentius,
Thanks for your inquiry.
I think, in your case, you can try wrapping your merge field inside IF field as follows:
IF {
MERGEFIELD Value1 } <= 0 “”
{ MERGEFIELD Value1 }
MERGEFIELD Value1 } <= 0 “”
{ MERGEFIELD Value1 }
Moreover, for a list of fields supported during update, please visit the following link:
I hope, this will help.
Best Regards,