PaXcel - functions > Sales Analysis

These functions will return values and details from the Sales person (Sales Analysis) file

SADetail( Company, Code, FieldToReturn )

Return master field for the given Sales Analysis code

SABalance( Company, Code, Period )

Will return the balance for the given period and code

SAGPBalance( Company, Code, Period )

Will return the GP Balance for the given period and code

SATarget( Company, Code, Number )

Will return the Target amount for the given number and code

SATargetPct( Company, Code, Number )

Will return the target percentage for the given number and code