How can I add 2 or more fields together in Crystal XI using the Formula Editor? I also need to know how to add a fixed amount to the total.

Currently, my Formula Field is called "Total Due" and in the formula editor it looks something like this:

{table.amount1} + {table.amount2} + {table.amount3} + 11.88

If I leave off the "fixed amount of 11.88", I get 3 amounts in my new field instead of the total amount. If I leave the fixed amount of 11.88 in the formula, I get an error message saying that a string is required here.

I'm sure this is easy if someone know the proper syntax.

Thanks in advance for any help - it's greatly appreciated!!!

tonumber({table.amount1}) + tonumber({table.amount3})  + tonumber({table.amount3}) + 11.88

 

And this fixed the problem.  Apparently the data is string as you mentioned.