Skip to Content
author's profile photo Former Member
Former Member

Exception aggregation in query - a chanlenge one

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 27, 2007 at 01:29 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2007 at 08:27 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2007 at 09:29 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2007 at 07:17 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 28, 2007 at 10:25 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.