2 Replies Latest reply: Aug 18, 2014 12:53 PM by David Auerbach RSS

    Suppress Missing not working with color function

      Hi all,

       

      I have an application where I use a variable to change which expression will display in a particular chart.  I also use a color function to change the color of the bars depending on a goal. Adding this seems to override "suppress missing" under presentation.  I can't use suppress zero because for some expressions, zero is a valid result.

       

      I tired using If() instead of sets and that didn't work.

       

      This sheet demonstrates what I mean. The charts are the same except for the color function... the one without the color function works but the one with does not.

       

      Ideas?

       

      Thanks!