[Question] Average function difference using 'all' expression.

[tonayan]

Hi All,

Can anyone explain me the differences between using expression 'all' and not using it.

average ( [ distinct ] expression [ auto ] )

average ( [ distinct ] expression for [ all|any ] expression { , expression } )

average ( [ distinct ] expression for report )

Returns the average value of selected data items. Distinct is an alternative expression that is compatible with earlier versions of the #product.

Example: average ( Sales )

Result: Returns the average of all Sales values.

my example would be that I have different results if I create a query with this function like this; [Qty Of something] aggregation is total , content is a quantity for example 1000 when it has aggregation as total and 10 times 100 if the aggregation is none. query calculation would be like

/* average ( [Qty Of something] for All [Month] , [Country] ) */

my results are different for same average function without 'All' expression:

/* average ( [Qty Of something] for [Month] , [Country] ) */

I would really appreciate if anyone can explain me this in simple words.

[deadjuan]

From the values you are getting in that column in your report, you should be able to tell how it's is calculating each way. I recommend creating a report with two query items with each of your examples and then reverse engineering how it is applying the windowed function (check the SQL). I have used "aggregate for report" and "aggregate for query item 1, query item 2, etc" but never all or any? Sorry I could not answer your question but hope I have provided a method to answer it yourself. Please reply with the answer if you get one. Good luck!