Calculated field based on options in a multi-select field | Community
Skip to main content
F
FemkeCr
Level 4
June 10, 2022
Question

Calculated field based on options in a multi-select field

  • June 10, 2022
  • 1 reply
  • 1355 views

Hi,

I want to add a calculated (currency) field to my custom form that calculates a sum value based on the options selected in the multi-select field.

SUM(IF(Field A multiselect="NL 01",25,IF(Field A multiselect="NL 02",50,0)))

When I select one option, the calculation works. However, when I select multiple options, the calculation fails.

Does anyone have an idea how to solve this riddle ;)?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
Community Advisor
June 10, 2022

I think probably consult the help article for calculated data expressions ( https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCalc_Cstm_Data-Reports%2Fcalculated-data-expressions.html&_LANG=enus ) and see if you can find some other commands to help achieve this (maybe "if contains" rather than a straight-up "if"? -- a field with multiple options selected feels like more of a "contains" than an "equals" ... in my mind, anyway)

Also, not that you asked, I confess I'm not the best at calculated expressions, but something about your calculation definitely looks a bit wonky. To me, it's saying "if field A is equal to NL 01, then the value is 25, OTHERWISE if field A is NL 02 then the value is 50 and if it's not NL 02, the value is 0." So to me it feels like there's no actual addition going on. Maybe if you play around with different combinations of parentheses I'll feel differently.

F
FemkeCrAuthor
Level 4
June 17, 2022

I can't get it to work, but thanks for your help anyway!

F
FemkeCrAuthor
Level 4
July 6, 2023

This is a late response, but I actually got this calculation working. Maybe I can help someone else with this calculation as well.

 

SUM(IF(CONTAINS("Option 1",{DE:custom field A}),DIV({DE:custom field B},10),0),IF(CONTAINS("Option 2",{DE:custom field A}),DIV({DE:custom field C},5),0)"")

    Terms & ConditionsAccessibility statement

    Loading footer...