This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I'm guessing the average number of days between invoices? E.g if the customer has 10 invoices a year then it should be 36.5

sorry mate, yeah that’s what i’m after!

I have to get some work in so I can try have a play a bit later hopefullly

But in *pseudo*-code probably something like `COUNT(transactions) / ({today} - MIN(transactiondate))`

would it be similar to also determine the amounts of days since the last invoice?

Something like `today - MAX(transaction date)`. But remind me a little later in the day and I can have an actual play