4 Replies Latest reply: Jun 10, 2015 12:56 PM by Marco Wedel RSS

    converting zeros formed by expressions into '-' and changing the background color to grey

    hemantha kumar bandari

      Hi

      I have a data coming from a database which are related to the particular regions where some regions do not have number at all and are represented as null but while using this as an expression on the view they are shown as zero as in an expression sum(null) or avg(null) are shown as zero. In the same way I have some zeros also coming in database which when summed are also shown as zero's in view. I am not able to differentiate between both zero's. I want to show the zero's caused by null as '-' and background greyed out and the zero's caused by actual zero's as it is.

       

       

       

      thanks in advance

       

      hemantha