Issue with the equation of calculated field

  • Resolved blue

    (@life2)


    11 months, 1 week ago

    Hi,

    I want to display the value from two fields in the calculated field, separated by a dash. Here is the equation I’m trying to use:

    (function(){
    if(fieldname1==1)
    {
    return fieldname2 – fieldname3;
    }
    else return fieldname4 – fieldname5;
    })();

    But this doesn’t work.

    Can you help with fixing the equation?

    Thanks.

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

    (@codepeople)

    11 months, 1 week ago

    Hello @life2

    Thank you very much for using our plugin. Please, use the CONCATENATE operation:

    IF(fieldname1 == 1, CONCATENATE(fieldname2, ' - ', fieldname3), CONCATENATE(fieldname4, ' - ', fieldname5));

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Issue with the equation of calculated field’ is closed to new replies.