I'm having trouble with formatting of calculated fields

[heymchr]

I have the following text tags in my Word document:

{{$E}}

{{$EMF  }}

{{#E=escrow_es_:checkbox:signer1}}

{{#EMF=emf_es_:signer1:calc(if(escrow = “checked”, 50, 0)):format(number, “$,0.00”)}}

The idea is when the signer checks the checkbox, the EMF field shows '$50.00', and if he leaves the box unchecked, the EMF field shows '$0.00'.

However, although the $50.00 shows OK when the box is checked, the value shows as 0 (instead of $0.00) if the box is unchecked. Is this a bug or am I defining my calculated field incorrectly?

Also, according to the user guide, the format (font,type,size) of the field will be based on the format of the first { but although I have set that to Arial bold 10pt, the field still shows as Helvetica plain 10pt. Any suggestions/ideas?

Thanks!

Christophe.

[SimonATS · Accepted solution]

try putting the 0 in quotes

:calc(if(escrow = “checked”, 50, "0"))