Category: Functions

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.

Deal 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 fnDealCount, we would type $(fnDealCount) into the expression editor.  To add your modifiers, add an open and close parentheses after the variable functions name, for example with our $(fnDealCount), to add modifiers we would type in $(fnDealCount(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.

fnDealPrice – the sum of the vehicle price based on the current selections.

fnDealCount – the count of all deal keys that are not set as a quote based on the current selections.

fnDealAccessoriesTotalSales – the sum of the accessories price from all deals that are not set as a quote based on the current selections.

fnDealAccessoriesTotalGross – the sum of the accessories price, less the accessories cost from all deals that are not quotes based on the current selections.

fnDealTotalGross – the sum of the total accessories gross profit, back end gross profit and vehicle gross profit from all deals that are not set as quotes based on the current selections.

fnDealVehicleGross – the sum of the vehicle gross from all deals that are not set as quotes based on the current selections.

fnDealBackEndGross – the sum of the F&I gross profit from all deals that are not set as quotes based on the current selections.

fnDealProtectionsGross – the sum of the deal protections sale price less the cost for all deals that are not set as quotes based on the current selections.

fnDealProtectionsSales – the sum of the deal protections sale price from all deals that are not set as quotes based on the current selections.

fnDealWarrantyGross – the sum of the deal warranty price, less the cost for all deals that are not set as quotes based on the current selections.

fnDealWarrantySales –  the sum of the deal warranty price from all deals that are not set as quotes based on the current selections.

fnDealReserveGross – the sum of the deal reserve gross profit from all deals that are not set as quotes based on the current selections.

fnDealInsuranceGross – the sum of the insurance price, less the insurance cost from all deals that are not set as quotes based on the current selections.

fnDealInsuranceSales – the sum of the insurance price from all deals that are not set as quotes based on the current selections.

fnDealQuotesCount – the count of all deal keys from deals that are set as quotes based on the current selections.

fnLeadCount – the count of all lead ids  based on the current selections.

fnDealFeeGross – the sum of the deal fees amount from all deals that are not set as quotes based on the current selections.

 

Loading...
X