Skip to Content
Former Member
Apr 28, 2009 at 01:26 PM

Count zero - in query


Hi Friends..

Please help me to fix this issue..

Query requirement is to find out the number of lines where the time effort is zero.

Row Column1 Column2

Group Time effort Count = 0

If a create a formula with DELTA(time effort) then only when I drill down the subgroup the query is able to count 0. But my requirement is to show only the Group and also count the number of zero at the subgroup level.

Is this possible ? If so, please explain.

Thanks & Regards,