<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Customer Functions > SLCatSales() |
SLCatSales( Company, CustomerCategory, Period )
This formula will return the total sales for the supplied customer category and period.
The arguments are as follows:
Company: This is the path to your Pastel data directory. For example:
c:\PastelData\_demo would enable you to retrieve information from the Pastel Partner demo company.
CustomerCategory: A customer category that exists within Pastel and that has been assigned to at least one customer account. Only single categories can be supplied in this function.
Period: This should be the period that you wish to return sales for. The period can be one of the following keywords. x - can be a period from 1 to 13.
Year to Date x - Sales for the year up to and including the period specified
Last Year to Date x - Sales for last year up to and including the period specified
Month x - Sales for period specified
Last Year x - Sales for the period last year specified
The following will return the total sales this year for End User customer category 1
SLCatSales( "c:\PastelData\_demo", 1, "Year to Date 12" )
The following will return the total sales for last year for the End User customer category 1
SLCatSales( "c:\PastelData\_demo", 1, "Last year to Date 12" ) |