AnsweredAssumed Answered

Calculation Field with & operator

Question asked by AlexOrrow on Jan 26, 2018
Latest reply on Jan 26, 2018 by philmodjunk

Hi,

 

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:

 

Field1 &

Field2 &

Field3 &

 

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:

 

field1: 450

field2: 0

field3: 0

 

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.

Outcomes