Hi I'm having some trouble. I'll give you an example of what I have in SQL

SQL:
distinct (count(NULLIF(field.column,0)))*100/distinct(count(field.column))

Basically have a table that has null and a range of 0-10 values. I need the 0 to be excluded from the count.

I have read, and read, and read and tried the suggestions that I had found using summaries and etc and had no success. I was hoping someone could shed more light into a successful way of accomplishing this in Crystal.

IS NULL is not the same as NULL IF.

I need the 0 values to become null or to exclude them. This is because I need count to only count the rows with data with data values of 1-10.


Edited by CR-Help - 30 Aug 2013 at 6:19am

Already tried. I get 0 or 1.00 as my values. 

That's correct, I need it to display inside the headers.

I tried a stored proc but if I do the data becomes static and it won't change if I choose a different value in the parameters. Wouldn't that be an issue with the data becoming static because I used in SQL contained where clauses, and, and or operators.

here's quick ex:

select count(NULLIF(a,0))/count(b) from table a inner join table b
on a.field = b.field
left join table c on c.field1 = b.field1
left join table d on d.field = a.field
where a.field between 'daterangehere' and 'datarangehere'
and c.field1 = 'anydatastring'

that's just an example of what the query looks like



Edited by CR-Help - 30 Aug 2013 at 9:14am