All Member != total of children

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Patrice Lamarche (patrice_lamarche_at_gcomnitech.com.nospam)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 11:21:19 -0400

Hello Everyone,

    I got strange result with this query ( a problem I got with another
query but i translate it to foodmart)

I would like to have the evolution during the first quarter children of 1997
of the product not sell in january

Here the query

With Member [Product].[ProductNeed] as 'Aggregate(Filter([Product].Members,
([Measures].[Unit Sales],[Time].[1997].[Q1].[1]) = null))'
select
    { [Time].[1997].[Q1].children} on columns,[Gender].members on rows
from sales where ( [Product].[ProductNeed],[Measures].[Unit Sales] )

I got this result

                        1 2 3
All Gender null 257 285
F null 1289 1423
M null 1174 1196

The number of the All Gender are exact ... But i don't know why F,M don't
fit.

If i use this query

With Member [Product].[ProductNeed] as 'Aggregate(Filter([Product].Members,
([Measures].[Unit Sales],[Time].[1997].[Q1].[1]) = null))'
select
    { [Time].[1997].[Q1].children} on
columns,{[Product].[ProductNeed],Filter([Product].Members, ([Measures].[Unit
Sales],[Time].[1997].[Q1].[1]) = null)} on rows
from sales

All number for each produt is ok

Thanks alot

Best Regards

Patrice

Relevant Pages

  • Re: Duplicate repetetive entries in query
    ... of the query where they are not equally matched. ... Given that i buy 20,000 units at x price, but Sell them in 5,000 lots. ... But in this query i would like a profit loss 'per trade'; ... (not a 'grouped sumed total' for that stock code going back to ...
    (microsoft.public.access.queries)
  • Re: Duplicate repetetive entries in query
    ... and Unique Records. ... Select one of them to be Yes, then rerun the query. ... > The question was how to eliminate duplicate entries on the Buy or Sell ... > Anyway i prepare this query base on two tables Smarket Buy & Smarket Sell ...
    (microsoft.public.access.queries)
  • Re: Select records by employee
    ... Static bRnd As Boolean ... USING the Random function will slow down the query, but I don't know of a better method to get the results as specified. ... The action only has 3 possible variables - buy, sell, hold. ... 10 buy, 10 sell and 5 hold for each employee, by supervisor. ...
    (microsoft.public.access.queries)
  • Re: Append with multiple criteria??
    ... discontinued, damaged, past shelf life, approaching shelf life, on quality ... Sell" how would one advise that I write the many different append queries to ... I don't think you need either a new field OR an Append query. ...
    (microsoft.public.access.queries)
  • Re: Sum by month query
    ... I need to create a query that will sum the sell by month where the quote number begins with QQ in the Quote Number field. ...
    (microsoft.public.access.queries)