Skip to main content

What modification I need to make in the following query to use in an older version of Tableau? I was using a newer version in which "IN" can be used for grouping, but the workbook isn't working in an older version due to that.

 

SUM(IF [Suborder Item Id]>0 AND 

  LEFT([Type Key],4) IN ('H.ES','H.WC','H.DP','H.AN','H.RQ','H.QL','H.CT','H.PD','H.OD','H.EU') 

  THEN [Count] END)

2 件の回答
  1. 2021年11月18日 12:23

    You'll have to do a series of explicit IF statements, one for each of the values you want to test for.

    So:

    IF LEFT([Type Key],4)='H.ES'

    OR LEFT([Type Key],4)='H.WC'

    ...

    THEN [Count]

    END