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.