3 Replies Latest reply on Oct 8, 2018 11:24 PM by philipp.gntzel

    How to remove null or NULL values from table calculations?

    philipp.gntzel

      Hello altogehter,

       

      currently I want to do something -seemingly- easy.

       

      I want to calculate the year-on-year difference percentage from one to another year.

       

      Now what happens is that some companies have monthly  values for last year but zeros or Null values for this year. Since I want to to the yoy comparison on average per month basis, these values would distort the average and thus the difference percentage.

       

      Thus, I need a filter which searchs for zeros or null values in a month and if there is a zero in one month a year, remove the whole month from the calculation.

       

      How can I achieve this (if possible without LODs)?

       

      Look at example / screenhots :-)

       

      Thanks in advance
      Philipp