3 Replies Latest reply on Jan 22, 2014 5:44 AM by Joshua Milligan

    Help with calculation to exclude values

    Peter Saddow

      Hi,

      I am trying to create a calculation that sums up the values and then create a line chart. The condition is, only include the 'Other' category value when it is greater than 0. What would the calculation be?

       

      This is my data set:

      DateCategoryValue
      1/1/2013A2
      1/1/2013B2
      1/1/2013Other-10
      1/2/2013A2
      1/2/2013B2
      1/2/2013Other10

       

      So, this is the result that I am looking for:

      -- The -10 is excluded from 1/1/2013

      -- The +10 is included from 1/2/2013

      DateSum
      1/1/20134
      1/2/201314

       

      Thanks!

      Peter