Exception aggregation in query - a chanlenge one

[Former Member]

Hi there,

I would like to count number of customers that their sold quantity is > 0.

I don't want to count customers that their sold qty is <=0 - Using exception aggr. that count all values<>0 is not good enough because it also count those with sold qty<0.

Any ideas?

Thanks, Nili

[Former Member · Accepted solution]

Can you use the condition then to filter the qty<0?

[Former Member]

Thank you for the idea but this key figure should be available for many reports.

We cannot afford ourselves building a workbook for each report.

I think that the requirement it is not something irregular but for some reason the BEx has no (common) solution for it.

All we need is counting all values >0 instead of counting all values<>0 in the exception aggregation.

[Former Member]

Your suggestion might be useful if the customers are displayed in the report.

The problem is that I do not want to display the customers in the report.

Defining "before aggregation" does not help neither because it brings wrong values - values from a more detailed resolution.

Thanks,

Nili

[Former Member]

Hi

you can acieve it in work books..

Hope it helps

Thanks

Teja

[Former Member]

You can create a formula like

(SALESQTY >0)*1

and put this in the columns. Summation this formula will give you count of customers who has salesqty >0.

Regs

Gopi

[Former Member]

I can not use a condition because I need this counting only in one column.

A condition will be global in the query.

I have one column counting the number of potential customers and another column that is supposed to show the number of customers with sales volume>0.

Thanks for your reply anyway.

Nili