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

    How to remove null or NULL values from table calculations?


      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