Text in a Number & Calculated Field

  • Resolved emiszcz

    (@emiszcz)


    7 years, 4 months ago

    Hi,
    Can I use combination of text and numbers in these fields?
    I would like to add unit symbols as sufix when the value meets my requirements. If form values are empty or don’t meet my criteria I print a text in Calculated field, so I would like to avoid using “Symbol to display at the end of calculated field” for that purpose.
    I use a formula:
    IF(AND(fieldname3,fieldname4>fieldname3),ROUND((fieldname4-fieldname3+fieldname16)/2.64* fieldname2),’enter valid values above’)

    • This topic was modified 7 years, 4 months ago by emiszcz.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @emiszcz,

    In this case you simply should edit the equation as follows:

    IF(AND(fieldname3,fieldname4>fieldname3),'$'+ROUND((fieldname4-fieldname3+fieldname16)/2.64* fieldname2)+' USD','enter valid values above')

    Best regards.

    Plugin Author codepeople

    (@codepeople)

    Hello @emiszcz,

    In this case you simply should edit the equation as follows:

    IF(AND(fieldname3,fieldname4>fieldname3),'$'+ROUND((fieldname4-fieldname3+fieldname16)/2.64* fieldname2)+' USD','enter valid values above')

    Best regards.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Text in a Number & Calculated Field’ is closed to new replies.