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 :The top one has 9 Orders and Amount Net for that Dept is 691.39 it shows 63, which is wrong. It really should be £76.82and the grand total should be £43.90 and not £149 - £10186.57 / 232 Orders = £43.90Is it possible to calculate this kind of Formula field (if it works) and display it on KPI? i.e - Today vs Yesterday -- £69.63 vs £43.90and then I could add another one, with Orders : Today vs Yesterday -- 76 vs 58Right now, All I am getting is the total orders....232