Hi,
I think I know how to do this via Grouping via customer then Avergae aggreagtion on my custom field (frequency)
But I dont know how to do the initial step (get the frequency): work out the days between each invoice per customer.
From there get an avergae from how many days on average a customer purchases.
; Ive downloaded XL2BB and its copied to clipboard successfully but I cant paste it within the reply?
*With very end game being as of Todays date is Customer A etc overdue puchasing from us....as its 24 days since last invoice date (seperate query to this) and the average days is 15 ; frequency custom field (im struggling with) grouped as an average.
Any help much appreciated.
Many Thanks
Gareth
I think I know how to do this via Grouping via customer then Avergae aggreagtion on my custom field (frequency)
But I dont know how to do the initial step (get the frequency): work out the days between each invoice per customer.
From there get an avergae from how many days on average a customer purchases.
; Ive downloaded XL2BB and its copied to clipboard successfully but I cant paste it within the reply?
*With very end game being as of Todays date is Customer A etc overdue puchasing from us....as its 24 days since last invoice date (seperate query to this) and the average days is 15 ; frequency custom field (im struggling with) grouped as an average.
Any help much appreciated.
Many Thanks
Gareth