2 Replies Latest reply on Aug 17, 2018 6:19 AM by Jim Dehner

    expression type string found float. Result types from 'CASE' expressions must match error

    Imran Azam

      HI

       

      I have the  following code bellow

       

       

      CASE [Sorty By]

      WHEN "Deal Value" THEN [Deal_Value]

      WHEN "Demand Value" THEN [Demand Value]

      WHEN "Allocated Value" THEN [Allocated Value]

      WHEN "Deal Coverage" THEN [Deal Coverage]

       

      END

       

      it is throwing an error message saying 'expression type string found float. Result types from 'CASE' expressions must match'

       

      how do i fix this?