8 Replies Latest reply: Jul 9, 2015 11:40 AM by Jes Lee RSS

    Creating measures

    Jes Lee

      I just created a measure setting min and max values-

       

      Here's the code.

       

      Sum({$<[100% Composite Index] ={">=$(=vMin) <=$(=vMax)"}>} [100% Composite Index])

       

       

      However, if there is no value, it's appearing as zero rather than null.  How do I get it to display a null value?

       

       

      Thank you,

      Jessica