8 Replies Latest reply on Sep 6, 2018 3:35 AM by Ravi Mistry

    Multiple IF ELSE IF STATMENTS for different measures

    sowjanya kolluru

      Hi all,

       

      I'm trying to build this multiple logical expression, somehow it is throwing error even if I put end at the bottom. Please can some one guide me with the correct formula.

      Can we achieve this in tableau?

       

       

      avg(IF  [Alias Segreggate (copy)] =  "Age" then [KRI Value])
      Avg(ELSEIF [Alias Segreggate (copy)] =  "CONC" then [KRI Value] )
      SUM(ELSEIF [Alias Segreggate (copy)] =  "COUNT" then [KRI Value])
      SUM(ELSEIF [Alias Segreggate (copy)] =  "Financial Values" then [KRI Value] )
      SUM(ELSEIF [Alias Segreggate (copy)] =  "OTHERS" then [KRI Value])
      avg(ELSEIF [Alias Segreggate (copy)] =  "per1000" then [KRI Value])
      avg(ELSEIF [Alias Segreggate (copy)] =  "Ratio" then [KRI Value] )
      sum(ELSEIF [Alias Segreggate (copy)] =  "Volume" then [KRI Value] )

      END

       

      thanks