4 Replies Latest reply on Nov 28, 2018 8:03 AM by Shinichiro Murakami

    Percent difference quick table calculations with null values

    john.garrigan.1

      Hi all,

       

      I wish to calculate the percent difference between columns for my data.

       

      The quick table calculations works great when I have data but when my underlying data has no entries it displays nothing which I fully understand

       

      My original table looks as follows:

       

      I then right click on the green pill and perform a quick table calculation (percent difference) which will produce the following screen of info:

       

       

      Is there a way to display 0% in Q2 and Q3 in 2018 in my marked out row?

       

      My underlying data has no values for this population (first column) and I have figured out how to replace NULL values with 0 using ZN and LOOKUP (ZN(LOOKUP(SUM([Measure]),0))) but once I replace my original green pill with the ZN measure I am unable to perform a quick table calculation.

       

      Or even better would be if I filtered down to just Q3 and Q2 that I would not lose the second row of data due to NULL values i.e. I would retain all rows even if there was no data for a row.

       

      Is there a solution/work around for this?