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

    Quick Table Calculations with missing values




      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.