3 Replies Latest reply on Jul 17, 2018 8:00 PM by kumar leau

    Add specific value to measure

    kumar leau

      Hi All,

       

      I am trying to achieve simple functionality as like below.

       

      case [Region]when'Central' then [Sales]+100

      when 'East' then [Sales]+200

      when 'South' then [Sales]+300

      else [Sales] end

       

      after created this calculated column I added to column shelf, but I am not able to expected results as adding 100 to wheb region is central.

      Can someone explain me where it is going wrong.

       

      Regards,

      Kumar