Loading...
X

Service Functions

The variable functions are a group of  measures that the Business Intel team has put together to further assist users with creating their very own expressions.  These are different from the measures that currently exist in the master library because you will be able to customize the measure to target the specific data you are looking for.  The functions start off as a very basic measure, and from there the user can add their very own modifiers so that only the data they are looking for will be included.  Each function can have up to 9 different modifiers.

To use a variable function, wrap the functions name in $(), for example to use the variable function fnLabourGP, we would type $(fnLabourGP) into the expression editor.  To add your modifiers, add an open and close parentheses after the variable functions name, for example with our $(fnLabourGP), to add modifiers we would type in $(fnLabourGP(Modifier1, Modifier2, Modifier3)).  Separate each of the modifiers with a comma.

The following list shows the different variable functions that have been created in the Business Intelligence application and a brief description of what each function is measuring.

fnCountROCasheried – count of distinct repair order numbers that have a status of Cashiered.

fnLabourCost – the sum of the cost of labour from repair orders that have a status of Cashiered.

fnLabourGP – the sum of the labour line price less the labour line cost from repair orders that have a a status of Cashiered.

fnLabourGP% = the sum of the labour line price, less the labour line cost, divided by the sum of the labour line price from repair orders that have a status of Cashiered.

fnLabourSales – the sum of the labour line price from repair orders that have a status of Cashiered.

fnLabourSalesPerRO – the sum of the labour line price, divided by the count of distinct repair order number from repair orders that have a status of Cashiered.

fnLabourSalesPayType – based on the cashiering date of the pay type, the sum of the labour line price from repair orders that are not void and the request lines are either original or approved status.

fnPartsROSalesPayType – based on the cashiering date of the pay type, the sum of the extended parts price from repair orders that are not void and the request lines are either original or approved status.

fnPartsROCostPayType – based on the cashiering date of the pay type, the sum of the extended parts cost from repair orders that are not void and the request lines are either original or approved status.

fnROCashieredPayTypeCount – based on the cashiering date of the pay type, the count of distinct repair order numbers from repair orders that are not void and the request lines are either original or approved status.

fnLabourGrossPayType – based  on the cashiering date of the pay type, the sum of the labour line price, less the labour line cost from repair orders that are not void and have request lines in original or approved status.

fnLabourCostPayType – based on the cashiering date of the pay type, the sum of the labour line cost from repair orders that are not void and have request lines in original or approved status.

fnPartsROGrossPayType – based on the cashiering date of the pay type, the sum of the parts line extended price, less the parts line extended cost from repair orders that are not void and have request lines in original or approved status.

fnLabourSalesCPPayType – based on the cashiering date of the customer pay portion of the RO, the sum of the labour line price from repair orders that are not void and have the request line in original or approved status.

fnLabourSalesWPPayType – based on the cashiering date of the warranty pay portion of the RO, the sum of the labour line price from repair orders that are not void and have the request lines in original or approved status.

fnLabourSalesIPPayType – based on the cashiering date of the internal pay portion of the RO, the sum of the labour line price from repair orders that are not void and have the request lines in original or approved status.

fnLabourGrossCPPayType – based on the cashiering date of the customer pay portion of the RO, the sum of the labour line price, less the labour line cost from repair orders that are not void and have the request line in original or approved status.

fnLabourGrossWPPayType – based on the cashiering date of the warranty pay portion of the RO, the sum of the labour line price, less the labour line cost from repair orders that are not void and have the request lines in original or approved status.

fnLabourGrossIPPayType – based on the cashiering date of the internal pay portion of the RO, the sum of the labour line price, less the labour line cost from repair orders that are not void and have the request lines in original or approved status.

fnLabourCostCPPayType – based on the cashiering date of the customer pay portion of the RO, the sum of the labour line cost from repair orders that are not void and have the request line in original or approved status.

fnLabourCostWPPayType – based on the cashiering date of the warranty pay portion of the RO, the sum of the labour line cost from repair orders that are not void and have the request lines in original or approved status.

fnLabourCostIPPayType – based on the cashiering date of the internal pay portion of the RO, the sum of the labour line cost from repair orders that are not void and have the request lines in original or approved status.

fnPartsROGrossCPPayType – based on the cashiering date of the customer pay portion of the RO, the sum of the extended parts line price, less the extended cost from repair orders that are not void and have the request line in original or approved status.

fnPartsROGrossWPPayType – based on the cashiering date of the warranty pay portion of the RO, the sum of the extended parts line price, less the extended cost from repair orders that are not void and have the request line in original or approved status.

fnPartsROGrossIPPayType – based on the cashiering date of the internal pay portion of the RO, the sum of the extended parts line price, less the extended cost from repair orders that are not void and have the request line in original or approved status.

fnPartsROSalesCPPayType – based on the cashiering date of the customer pay portion of the RO, the sum of the extended parts line price from repair orders that are not void and have the request line in original or approved status.

fnPartsROSalesWPPayType – based on the cashiering date of the warranty pay portion of the RO, the sum of the extended parts line price from repair orders that are not void and have the request line in original or approved status.

fnPartsROSalesIPPayType – based on the cashiering date of the internal pay portion of the RO, the sum of the extended parts line price from repair orders that are not void and have the request line in original or approved status.

fnPartsROCostCPPayType – based on the cashiering date of the customer pay portion of the RO, the sum of the extended parts line cost from repair orders that are not void and have the request line in original or approved status.

fnPartsROCostWPPayType – based on the cashiering date of the warranty pay portion of the RO, the sum of the extended parts line cost from repair orders that are not void and have the request line in original or approved status.

fnPartsROCostIPPayType – based on the cashiering date of the internal pay portion of the RO, the sum of the extended parts line cost from repair orders that are not void and have the request line in original or approved status.

fnLabourSoldHoursPayType – based on the cashiering date of the pay type, the sum of the sold hours on the labour line from repair orders that are not void and have the request line in status original or approved.

fnLabourSoldHoursCPPayType – based on the cashiering date of the customer pay type, the sum of the sold hours on the labour line from repair orders that are not void and have the request line in status original or approved.

fnLabourSoldHoursWPPayType – based on the cashiering date of the warranty pay type, the sum of the sold hours on the labour line from repair orders that are not void and have the request line in status original or approved.

fnLabourSoldHoursIPPayType – based on the cashiering date of the internal pay type, the sum of the sold hours on the labour line from repair orders that are not void and have the request line in status original or approved.

fnLabourActualHoursPayType – based on the cashiering date of the  pay type, the sum of the actual hours on the labour line from repair orders that are not void and have the request line in status original or approved.

fnLabourActualHoursCPPayType – based on the cashiering date of the customer pay type, the sum of the actual hours on the labour line from repair orders that are not void and have the request line in status original or approved.

fnLabourActualHoursWPPayType – based on the cashiering date of the warranty pay type, the sum of the actual hours on the labour line from repair orders that are not void and have the request line in status original or approved.

fnLabourActualHoursIPPayType – based on the cashiering date of the internal pay type, the sum of the actual hours on the labour line from repair orders that are not void and have the request line in status original or approved.

fnROCashieredCPPayTypeCount – based on the cashiering date of the customer pay portion, the count of distinct repair order number from repair orders that are not void and have the request status as original or approved.

fnROCashieredWPPayTypeCount – based on the cashiering date of the warranty pay portion, the count of distinct repair order number from repair orders that are not void and have the request status as original or approved.

fnROCashieredIPPayTypeCount – based on the cashiering date of the internal pay portion, the count of distinct repair order number from repair orders that are not void and have the request status as original or approved.

fnSubletSalesPayType – based on the cashiering date of the pay type, the sum of the sublet line price from repair orders that are not void, and have the request line status of original or approved.

fnSubletSalesCPPayType – based on the cashiering date of the customer pay type, the sum of the sublet line price from repair orders that are not void, and have the request line status of original or approved.

fnSubletSalesWPPayType – based on the cashiering date of the warranty pay type, the sum of the sublet line price from repair orders that are not void, and have the request line status of original or approved.

fnSubletSalesIPPayType – based on the cashiering date of the internal pay type, the sum of the sublet line price from repair orders that are not void, and have the request line status of original or approved.

fnSubletCostPayType – based on the cashiering date of the pay type, the sum of the sublet line cost from repair orders that are not void and have the request line status of original or approved.

Subscribe Now

Get BI Blog updates straight to your inbox

Name *

Email *