12 Replies Latest reply: Oct 9, 2015 6:55 AM by Vivek Gajjar RSS

    Set analysis exclude null

    Niels van de Coevering

      I'm trying to create a set analysis and exclude null records on a field. Something like this:


      Sum({$<Group -= Null()>} Amount)


      I found something saying to do it like the following line, but the editor still gives me a curly red underlining.


      Sum({$<Group={*}>} Amount)


      Could someone give me the right way to do this?

      I'm working with QV version 11 RC.