Creating a calculated field that uses if/then logic | Adobe Higher Education
Skip to main content
P
Pat_Paterson
Level 4
October 25, 2023
Répondu

Creating a calculated field that uses if/then logic

Hi All,

I'm attempting to create a calculated field that is based on an asset field with 97 different selections. The way I'm envisioning it is if a particular group of assets are selected from the previous custom field, the calculated field with display text such as "Graphic". There's going to be about 17 different options/text that I want to display.  Is this possible to pull off using a calculated field?

Meilleure réponse par skyehansen

Honestly, this is a grey area for me.  I wouldn't know where to start with creating a calculated field with multiple IFIN formulas in it.  what formula would I need to start with in order to get that going?


hi Seth, you would start with the original formula in the link I posted above, and just continue to add to it. The original formula is this:

 

IFIN(value, value1, value2,..., trueExpression, falseExpression)

 

 

Let's refer to the above as one complete IFIN statement.

If you had two options, you would want to sub out the falseExpression for another complete IFIN statement, e.g.:

 

IFIN(value, value1, value2,..., trueExpressionA, IFIN(value3, value4, value5,..., trueExpressionB, falseExpression))

 

 

If you had 3 options, you would swap out the falseExpression yet again, like this:

 

IFIN(value, value1, value2,..., trueExpressionA, IFIN(value3, value4, value5,..., trueExpressionB, IFIN(value6, value7, value8,..., trueExpressionC, falseExpression)))

 

 

You mentioned you had 17 options, so you would just do this another 13 or 14 times (I would test each time in order to make sure that each option was coming in, before adding a new option).

 

Doug dH does give a real world example here as well (with 2 options): 

https://experienceleaguecommunities.adobe.com/t5/workfront-ideas/add-switch-function-to-calculated-field/idi-p/581636

1 commentaire

RandyRoberts
Community Advisor
RandyRobertsCommunity Advisor
Community Advisor
October 25, 2023

Short answer: maybe.

Can you post an example of what it might look like (in plain English)? When you say "if a particular group of assets are selected from the previous custom field", what will define that "group"?

You can always say IF({field name} equals "this value", then,display "This", if not then display "That") but I think you're asking for more than a simple if/else statement.

    P
    Pat_PatersonAuteur
    Level 4
    October 25, 2023

    sure, when I say group, I mean of the potential 97 asset options from the previous field, maybe 6 of them when selected will have the same answer in the calculated field such as "Graphic".  So, in theory this calculated field will be grouping them together.

    skyehansen
    Community Advisor
    skyehansenCommunity Advisor
    October 25, 2023

    I think Seth might be asking about something like "if I pick apple, banana, orange or grapes from the original field, I want the calculated field to display "fruit", but if I pick broccoli, lettuce, asparagus or spinach, I want it to display "vegetables"". If this is the case, you might want to take a closer look at the IFIN syntax from here:

     

    https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions.html?lang=en

      Conditions d'utilisationAccessibility statement

      Loading footer...