<< Click to Display Table of Contents >> Navigation: PaXcel - functions > Sales Analysis > SAGPBalance() |
SAGPBalance( Company, Code, Period )
This function will return the Gross Profit balance for the analysis code and period specified.
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.
Code: Enter the salesperson or sales analysis code to return the information for
Period: This should be one of the following period keywords
Month x - will return the Gross Profit (GP) balance for the specified period
Year to Date x - will return the total GP balance up to and including the specified period
Last Year Month x - will return the GP balance for the specified period last year
Last Year To Date x - will return the GP total balance up to and including the specified period for last year
The following will return the GP balance for period 3 from analysis code 00001
SAGPBalance( "c:\PastelData\_demo", "00001", "Month 3" )
The following will return the total GP balance up to and including period 5 this year for code 00001
SAGPBalance( "c:\PastelData\_demo", "00001", "Year To Date 5" )
The following will return the total GP balance for last year up to and including period 5 for code 00001
SAGPBalance( "c:\PastelData\_demo", "00001", "Last Year To Date 5" )
|