Hi everyone,
Im trying to calculate the average monthly sales for the last 12 months for a customer / customers when generated by Netsuite.
Below is my criteria
Date - is within 365 days ago
Billing Status : is closed
Main Line : is true
Type : is Invoice
Results
Amount (Net of Tax) (summary type = average)
It appears to perform a calculation
I'm leveraging this via a suitelet, which injects the customers Internal ID which is doing its thing correctly. - My question is, is this the correct structure to calculate the average monthly sales for a customer
Any help greatly appreciated as this is an area that is completely foreign to me
thanks in advance