Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Average Order Value & KPI
Hi Peeps!
I have created a Average Order Value saved search (I Dont know if you can do this on a Report, if so can anyone help?) - Basically it adds all the Transaction Numbers together and then in another column adds all Amount Net. This bit works. so I am trying to extend this further to get the average per dept and then add a count at bottom.
Assuming it would be simple divide Amount Net by total number of Orders.
I created this formula but it does not work.
sum({transaction.netamount}) / count({transaction.number})
I am getting this screen :
0