Auto Fields not totaling correctly.

[David]

I have an invoice fill in form as follows:

User enters the fee amount in a Fillin field, which is
bookmarked as "NetFee"

The next field is a locked one that calculated GRT, which
it does correctly, and is bookmarked as "GRT"

The next field is locked and has the following
formula: "=Sum(Netfee,GRT)", which should add the NetFee
to the GRT and give the total.

The problem is if we say the fee is $200.00, the GRT
calculates as $13.38, which is correct, but it makes the
total $213.76, which is adding the $.38 in twice. Is there
a better way to write the formula, or what do I have wrong?

Thank you
David

 

[macropod]

Hi David,

You could use a simpler field like:
{=NetFee+GRT}

Your formula should work, though.

Cheers
PS: You could use as ASK feild to get the NetFee amount,
eg:
{ASK NetFee "What is the NetFee?"}, then a REF field to
display the NetFee value wherever you need it:
{NetFee}
This frees you from having to put the prompt in the same
part of the document that the result is required, as the
ASK field creates its own book mark but doesn't
automatically display the result at that point.