Count(Difference=0) as a pie chart expression

[#1]

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!

[jonathandienst]

Hi

The expressions should be like:

     Count({<Difference = {0}>} <some field that is never null>)

     Count({<Difference -= {0}>} <some field that is never null>)

Count needs to count something, so use a field that has no null values and replace the placeholder in these expressions with that field name.

HTH

Jonathan