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