5 Replies Latest reply on Jul 6, 2017 3:30 PM by Deepak Rai

    No color for a computed field if no more values

    joe sparty

      Hello,

       

      I'm using the following 2 computed fields to color change from month to month:

      color1.pngcolor1-1.png

       

      I'm able to color in a view based on !LoanBalChgDistrictRisk:

      color2.png

       

      The issue is when a district is closed, in this example it was closed in Aug.:

      color3.png

       

      Is there a way to assign no color when there is no value in a month?

       

      Thanks,

      -Joe