Skip to Content
0
Former Member
Sep 11, 2009 at 08:12 AM

Group By Operator and statistics operation

104 Views

Hi all,

in my model from the data service I obtain these fields

sold_to (T)

delivery_date (D)

quantity (N)

zdiff_date (N)

zindex (N)

I have to present a table where I have a row for each SOLD_TO and in the columns I'd like to show the average values.

So the situation should be:

sold_to | quantity (AVG) | zdiff_date (AVG) | zindex (AVG).

For this I use the Group by operator where on SOLD_TO field I apply the Group1 and for the others fields I use the average operation.

My problem .... I don't see the results..... all the average fields are empty but if I apply the sum (for instance) I obtain the right results.

Where is the problem? Have you ever seen or tested this kind of situation?

Regards, Roberto