String function on Attributes not working - InventoryItem

You don’t want the equal signs in your formula. Remove these...

You might find a Switch formula easier to work with in this case rather than repeated IIFs and then use an ISNULL to replace the null values. 

=ISNULL(SWITCH(InStr([ATTR_USES.Value], 'Hiking')>0, ‘Outdoor’, InStr([ATTR_USES.Value], 'Athletic')>0, ‘Athletic’), 'Casual')

Can you share a screenshot of your join to CSAnswers?

After CSAnswers, you will also want to join to the table CSAttributeDetail for combo attributes to access the description field.

​@chese79 ,
can you pls try like this formula
=IIF(InStr([ATTR_USES.Value], 'Hiking')>0, 'Outdoor', 
  IIF(InStr([ATTR_USES.Value], 'Athletic')>0, 'Athletic', 
    'Casual'))
Below is AI generated response:
 

Missing GIWhere for AttributeID on the join

Looking at your XML, you have a GIWhere filtering ATTR_USES.AttributeID = 'USES', but your join (GIOn) links on noteID = RefNoteID with an Inner Join (JoinType="I").

The raw Value column appearing blank strongly suggests the WHERE condition on AttributeID is being applied before the join resolves correctly, or there's a conflict between the inner join and the WHERE clause filtering it out.

Fix — move the AttributeID filter into the GIOn condition instead of GIWhere:

In the GI designer, add a second GIOn line under the same relation:

• Parent Field: (Expression)
• Condition: E
• Child Field: ATTR_USES.AttributeID
• Value: 'USES'

Then remove the GIWhere row for ATTR_USES.AttributeID. Keeping it in WHERE rather than ON with an inner join can cause the raw value to be filtered out before the result columns are evaluated, which explains the blank USES Raw Value column.