4 Replies Latest reply on Jan 16, 2019 8:04 AM by john.garrigan.1

    Quick Table Calculations with missing values

    john.garrigan.1

      Hi,

       

      I am working with a table of values for which I would like to calculate the QoQ increase/decrease.

       

      Some of my quarters have no values and I would like them to be treated as zeros for the purposes of the quick table calculations. When I perform the quick table calculation for 2018 Q3 vs Q2, one of my rows disappears since the data is missing for both quarters.

       

      Is there a simple way to display 0% instead of dropping the row completely?

       

      My data looks as follows, unfortunately I can't share the workbook as the data is proprietary.

       

      I have now added a sample workbook which shows the problem I am working with.