Hello,

Im having a problem summing 2 columns of data togather.
I have a column head "MySum:Sum([Field1]+[field2])". say both fields contain the value 1. I would expect the answer to be 2 but instead I get 11 (1 and 1 instead of 1+1).

What am I doing wrong here?

Thanks

I'm guessing that you have field1 and field2 set as text. Try using:

sum(val([field1])+val([field2]))

Or

Sum(Field1) + Sum(Field2)

David

Thanks! Thats seems to have got it :)