cancel
Showing results for 
Search instead for 
Did you mean: 

Count zero - in query

Former Member
0 Kudos

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,

Surjit

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Surjit,

In the rows, put only group. In the column, Put time effort and one formula.

In the formula put "Time Effort == 0".

In the aggregation tab of the formula, Exception aggregation = 'Total". Ref Character = "Sub Group".

Let us know if it works...

Regards,

BIJESH

Former Member
0 Kudos

Hi,

Great!! ..It worked.. Many thanks..

Regards,

Surjit

Answers (4)

Answers (4)

Former Member
0 Kudos

Yes, I have tried that. It doesn't work.

Is there any other way to do it?

Former Member
0 Kudos

Hi,

Have you tried with Aggregation "Counter for all detail Value" and "Counter for all detail Values that are Not Zero."

Regards,

Former Member
0 Kudos

Hi,

Many thanks for the reply.

Actually I am interested in changing the modeling. Can we do this in query ?

Regards,

Surjit

Former Member
0 Kudos

Hi there,

You can use this:

[https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/7e58e690-0201-0010-fd85-a2f29a41c7af]

The only difference when implementing this, you can the characteristic you insert in the cube equal to 1 in particular situations, in your case when time effort equal to zero.

This will count all of those occurences and display the result in the query independent of the drill down.

Diogo.