5 Replies Latest reply: Jun 30, 2017 8:12 AM by Partha Kulkarni RSS

    Exclude zero value in Bar Chart


      The site is not allowing me upload the image. I want to exclude the zero value in Bar Chart. Can anyone help in this regards?


      CY - Sum({<Year = {'$(=Max(Year))'}>} Sales)

      LY - Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)




      After applying


      CY - if(Sum({<Year = {'$(=Max(Year))'}>} Sales)>0,Sum({<Year = {'$(=Max(Year))'}>} Sales))

      LY - =if(Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)>0,Sum({<Year = {'$(=Max(Year)-1)'}>} Sales),'')