I have a calculation field that grabs numbers from separate fields on a single record, there is only ever data entered into one single field for each record. I am using the "&" operator in the following way:
The purpose is to capture the data in various fields into one field for each record over many records into one field.
I am finding though that for any number above 300 I dont get the result I was expecting. For example
if record1 had data entered in the following way:
I would expect the calculation field to grab the 450. Instead it enters 0030000000. Below 299 the data is captured fine.
I can't figure out why this is happening. I sure this is the wrong way to go about capturing data from other fields. I'd be grateful for any guidance as to why this happening? Thank you.