Word calculation with mailmerging

I have a mail merge gap where it will bring in a figure from an external software (for this example we will call it "Balance") underneath we have another that will also be brought in (for this example we will call it "Payment 1"), which I need to have the sum of both dog and cat underneath.

Balance >> 0.00 >> this figure, if 0 on the external software will come in as a blank figure, but other times it will be a balance on account. This is where I am no good, and need an IF formula that will say IF blank then show 0.00 if not then show the number

Payment 1 >> 0.00 >> this figure will just be a number brought in

Total >> 0.00 >> this needs to be "Balance" & "Payment 1" but obviously "Balance" is going to be complicated due to having to contain an IF.

______

I currently have this;


Balance { IF "{ MERGEFIELD Balance }" <> "" "{ MERGEFIELD Balance }" "0.00" }

Payment 1 { MERGEFIELD Payment 1 }

Total { = { IF "{ MERGEFIELD Balance }" <> "" "{ MERGEFIELD Balance }" "0.00" } + { MERGEFIELD Payment 1 }


It works for when there is a number but has a syntax error when the figure is 0

I think this is because The Merge field is looking for some form of data. The key with lists/info used in Mail Merge is that there can not be any gaps or missing information. I have seen people trying to use Mail Merge with an Excel spreadsheet that had lots of missing information - Mail Merge struggles with this particularly when doing envelopes!!!