5 Replies Latest reply: Sep 15, 2017 10:32 AM by Josh Akehurst RSS

    Colors with Custom Expression on Null values

    Josh Akehurst

      I would like to use a custom expression to display a Green/Red color output on a donut chart, but nothing is working.  I define anything null in the field as 'Unassigned' otherwise 'Assigned'.  Here are the expressions involved. 

       

      Dimension

      =if(IsNull([Resolution]), 'Unassigned', 'Assigned' )

       

      Colors and Legend

      =if(IsNull([Resolution), RGB(72,196,117), RGB(231,97,74))

      Also tried

      =if(IsNull([Resolution]), RGB(72,196,117), if(Not isNull([Resolution]), RGB(231,97,74), RGB(0,0,0)))

       

      The only color displayed is Green (Not red for the Unassigned/Null values)

       

      Screen Shot 2017-09-14 at 4.02.49 PM.png