Conditional Formulas in Calculated Fields

  • Manuel

    (@marowi)


    2 years, 6 months ago

    Dear Crocoblock-Team,

    I have a question regarding conditional formulas in calculated fields.

    Let’s say I have two fields:

    1) A select field with the field name “business_model” and the two values “B2B” and “B2C”

    2) A calculated field with the following formula:

    ( %FIELD::business_model% == ‘B2B’ ) ? 50 : 10

    Even if I select “B2B” in the select field, 10 is displayed.

    Is it possible that such conditions do not work with text values?

    If I give them a numerical value, e.g. 1 for “B2B” and 2 for “B2C”, then at least this formula works:

    ( %FIELD::business_model% == 1 ) ? 50 : 10

    However, it is not very practical to select numerical values because these are also sent (e.g. by email) instead of the actual select field names.

    • This topic was modified 2 years, 6 months ago by Manuel.

The topic ‘Conditional Formulas in Calculated Fields’ is closed to new replies.