More than 1 result in Calculated Field

  • Resolved kobijae88

    (@kobijae88)


    6 years, 6 months ago

    Hi there i’m looking to use the calculated field to show the result of one set of dependencies OR another.

    My structure is like this:

    Dropdown fields:
    – First field selection shows 2 checkboxes with dollar values. When those are selected, the result is shown in a calculated field. OR
    – Second field selection shows 3 checkboxes with dollar values. When those are selected, the result is shown in the same calculated field as above.
    – Third field selection shows 4 checkboxes with dollar values. When those are selected, the result is shown in the same calculated field as above.

    How can I get the calculated field to show either/or of these 3 results? Or is there a better way to do this?

    Thank you!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    Hello @kobijae88,

    You simply should sum all these checkboxes fields, because the values of the dependent fields when are disabled is zero.

    For example, if you sum: fieldname1+fieldname2+fieldname3, where fieldname1, fieldname2 and fieldname3 are fields dependent on different choices in a dropdown field, the result of the equation would be only the value corresponding to the dependent field that is active (fieldname1, fieldname2 or fieldname3).

    Best regards.

    Thread Starter kobijae88

    (@kobijae88)

    Oh of course, that makes perfect sense! Thank you for such a quick and helpful reply!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘More than 1 result in Calculated Field’ is closed to new replies.