3 Replies Latest reply on Jan 20, 2017 11:43 AM by Greg Doucette

    Suppress Table Calc When Data not Available

    Greg Doucette

      I have a worksheet where I am comparing weekly expenses year over year using the Difference table calculation.  The user wants to see all 52 weeks across the X axis throughout the year, but to only populate the columns as data in the current year becomes available.  By default, the difference calc is returning results for weeks that have not occurred yet by using 0 as the 2017 value.

       

      Is there a way to place a condition on the table calc to suppress the result or return 0 if the value in the current cell is 0 or null?