6 Replies Latest reply on Oct 10, 2018 2:00 PM by nikher verma

    How to see the negative numbers in Bin Calculated Measure

    Donovan Thomas

      Hello,

       

      I have help create an Bin off of these two Measures Delta YTD and Advertiser

      Also using the this Calculation:

       

      if [Delta YTD] >=0 and [Delta YTD] <400 then '0-399'

      ELSEIF [Delta YTD] >=400 and [Delta YTD] <800 then '400-799'

      ELSEIF [Delta YTD] >=800 and [Delta YTD] <1200 then '400-1199'

      ELSEIF [Delta YTD] >=1200 and [Delta YTD] <1600 then '1200-1599'

      ELSEIF [Delta YTD] >= 1600 then '>1600'

      END

       

      Which it works.

       

      Captureva.JPG

       

      But I want to see the negative numbers so I try this Calculation:

       

      if [Delta YTD] <-800 then '< -801'

      ELSEIF [Delta YTD] >=-800 and [Delta YTD] <-400 then '-800 - -401'

      ELSEIF [Delta YTD]>=-400 and [Delta YTD] <0 then '-400 - 0'

      ELSEIF [Delta YTD] >=0 and [Delta YTD] <400 then '0-399'

      ELSEIF [Delta YTD] >=400 and [Delta YTD] <800 then '400-799'

      ELSEIF [Delta YTD] >=800 and [Delta YTD] <1200 then '400-1199'

      ELSEIF [Delta YTD] >=1200 and [Delta YTD] <1600 then '1200-1599'

      ELSEIF [Delta YTD] >= 1600 then '>1600'

      END

       

      But it come out like this:

      Captur,Me.JPG

       

       

      Is there a way to show the negative numbers??