1 Reply Latest reply: Feb 17, 2015 6:02 AM by Jonathan Dienst RSS

    Count(Difference=0) as a pie chart expression

      Hi all,

       

      This might be a really simple question to you all but i'm struggling a bit so would really like some help, thanks a lot in advance.

       

      I am creating this pie chart with the hope to demonstrate the number of difference (between the same variable in two difference dataset) that are 1) =0, 2) <>0 . The field name I used is called 'Difference' and so my two expressions are 1) Count(Difference=0) and 2) Count (Difference <>0).  However the end result is just showing me half and half for each expression which doesn't match the actual data.

       

      Does anyone one know what went wrong and how I could rectify this?

       

      Thanks again!