I'm trying to return a BLANK value in a mail merged document where there might be a syntax error due to there being no data in the source excel document.
In the mail merged document, I've got {=«Percent»*100 # 0%}, however if there is no data from the source document it returns "!Syntax error"
This is the what I'm using to try and combat that, { IF { =«Percent»* 100 } <> "!Syn*" "{ =«Percent» * 100 \# "0%" }" } but it doesn't seem to be working.
In the mail merged document, I've got {=«Percent»*100 # 0%}, however if there is no data from the source document it returns "!Syntax error"
This is the what I'm using to try and combat that, { IF { =«Percent»* 100 } <> "!Syn*" "{ =«Percent» * 100 \# "0%" }" } but it doesn't seem to be working.
Last edited: