field codes showing up in merge doc

[teqqilawilly]

I am creating a table that pulls values from the data
sheet with an IF condition. I have set the value as a
variable that I want to call in the table for
calculations. Here is an example:
{SET line1 {IF {Mergefield NewFee }="Yes" {Mergefield
NewFeeValue }""}}
Now I want to calculate a sum of variables line1 and line2
in the merged document. When I merge using either the
built-in Table>Formula function or creating an
Insert>Formula expression, I get the field codes. Here is
an example:
{=SUM(line1,line2)\# "#,##0.00"}.
After the merge I can toggle the field codes and see the
resulting value. But if I update the table, I get an
error that Bookmark line1 is not valid.

Can I please get some help on how to make the calculation
work in the merge?

Thanks.
TW