has anyone ever run into an issue on sales order r...
# administratione
Eric Shouler
01/12/2021, 9:48 PMhas anyone ever run into an issue on sales order reporting where quantities sold won't display average when selected from the column drop down?
Eric Shouler
01/12/2021, 9:49 PMI tried doing it with a different column, but it didn't work hence the 0.
Eric Shouler
01/12/2021, 9:49 PMThe 3,390 number is good, but I also need to get the avg qty sold across the sales orders in the second column.
n
Netsuite Tragic
01/12/2021, 9:55 PMadd another Qty column and make the Summary for the new Column as "Average"
e
Eric Shouler
01/12/2021, 9:59 PMthats what I tried with the previous columns, they don't stick. They return summed qty.
n
Netsuite Tragic
01/12/2021, 10:02 PMwhich is the base report you modified please
e
Eric Shouler
01/12/2021, 10:03 PMSales Order by Item Detail
n
Netsuite Tragic
01/12/2021, 10:11 PMi'm seeing the same as you, it doesn't calculate the way we expected. If you don't see anyone else chip in with help then a Saved Search would be my preferred method.
e
Eric Shouler
01/12/2021, 10:12 PMI'm going to have to go that route. What a pain, because client needs comparative avgs across dates and locations😑
n
Netsuite Tragic
01/14/2021, 3:52 AMyou could spend some time in Netsuite Analytics. I always come away disappointed when I try something like you want in Analytics.