3 Replies Latest reply: May 10, 2013 8:56 PM by Nagaian Krishnamoorthy RSS

    Sum total negative margin of a total invoice.

      Hi Guys,

       

      I'm new to qlikview.

       

      I'm trying to sum the total negative margin and group that by invoice.

       

      So the result I'm after is the total negative margin of the total invoice.

       

      I tried using the following expression;

      sum({<margin={"<0"}>} margin)

       

      however using this expression It is summing the total negative margins line by line rather than the total of the invoice where it is a negative margin.