Skip to main content
Participant
January 3, 2014
Answered

I'm having trouble with formatting of calculated fields

  • January 3, 2014
  • 1 reply
  • 892 views

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.

This topic has been closed for replies.
Correct answer SimonATS

try putting the 0 in quotes

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

1 reply

SimonATSCorrect answer
Legend
January 6, 2014

try putting the 0 in quotes

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