Concatenate String for Calculated Field

  • Resolved jrgalia

    (@jrgalia)


    4 years, 8 months ago

    How to concatenate String with a Calculated Field. The Calculated Field (fieldname3) has the following formula, also a concatenation that works.

    `”X” + fieldname1 + fieldname2

    But when using the fieldname3 in another calculated field, I can only get the digit, the string was excluded.

Viewing 1 replies (of 1 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @jrgalia

    The plugin always tries to extract the numbers from the values of calculated fields to use them in the mathematical operations.

    However, if you want to access to the raw value, without pre-processing, you should to use the names of the fieldl in the equations with the |r modifier, as follows: fieldname3|r

    For example, if you want concatenate the raw values of calculated fields: fieldname3 and fieldname4, you can use the following equation:

    
CONCATENATE(fieldname3|r, fieldname4|r)

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Concatenate String for Calculated Field’ is closed to new replies.