Loading...
X

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.

 

Subscribe Now

Get BI Blog updates straight to your inbox

Name *

Email *