Resource Hero Rollup Fields

The following fields, when created on your custom object, will be automatically kept up to date by Resource Hero.  While you could choose whatever you like for the field Label, take special care to copy the field names exactly as is listed.

Forecast Rollups

RH Total Forecast Hours

Description / Help Text:  The total of all hours inputted within the forecast matrix.

Type:  Number

Field Name: RH_Total_Hours

Length:  16

Decimal Places:  2

Default Value:  0

API Name:  RH_Total_Hours__c

 

RH Total Forecast Amount

Description / Help Text:  The total amount based on the sum of all forecast hours inputted multiplied by the assignment rate.

Type:  Currency

Field Name: RH_Total_Amount

Length:  16

Decimal Places:  2

Default Value:  0

API Name:  RH_Total_Amount__c

 

RH Total Forecast Cost

Description / Help Text:  The total cost based on the sum of all forecast hours inputted multiplied by individual resource cost rates.

Type:  Currency

Field Name: RH_Total_Forecast_Cost

Length:  16

Decimal Places:  2

Default Value:  0

API Name: RH_Total_Forecast_Cost__c

 

Actual Rollups

RH Total Actual Hours

Description / Help Text:  The total of all hours inputted within the actual and time tracking matrices.

Type:  Number

Field Name: RH_Total_Actual_Hours

Length:  16

Decimal Places:  2

Default Value:  0

API Name:  RH_Total_Actual_Hours__c

 

RH Total Actual Amount

Description / Help Text:  The total amount based on the sum of all actual hours inputted multiplied by the assignment rates.

Type:  Currency

Field Name:  RH_Total_Actual_Amount

Length:  16

Decimal Places:  2

Default Value:  0

API Name:  RH_Total_Actual_Amount__c

 

RH Total Actual Cost

Description / Help Text:  The total cost based on the sum of all actual hours inputted multiplied by individual resource cost rates.

Type:  Currency

Field Name:  RH_Total_Actual_Cost

Length:  16

Decimal Places:  2

Default Value:  0

API Name:  RH_Total_Actual_Cost__c

 

Comparison Fields

RH Remaining Forecast Hours

Description / Help Text:  A formula that calculates the difference between the Actual and Forecasted hours.

Type:  Formula – Number

Field Name:  RH_Remaining_Forecast_Hours

Length:  16

Decimal Places:  2

FormulaRH_Total_Hours__c - RH_Total_Actual_Hours__c

API Name:  RH_Remaining_Forecast_Hours__c

 

RH Remaining Forecast Amount

Description / Help Text:  A formula that calculates the difference between the Actual and Forecasted amount.

Type:  Formula – Currency

Field Name:  RH_Remaining_Forecast_Amount

Length:  16

Decimal Places:  2

FormulaRH_Total_Amount__c - RH_Total_Actual_Amount__c

API Name: RH_Remaining_Forecast_Amount__c

 

RH Remaining Forecast Cost

Description / Help Text:  A formula that calculates the difference between the Actual and Forecasted cost.

Type:  Formula – Currency

Field Name:  RH_Remaining_Forecast_Cost

Length:  16

Decimal Places:  2

FormulaRH_Total_Forecast_Cost__c - RH_Total_Actual_Cost__c

API Name: RH_Remaining_Forecast_Amount__c

 

Other Fields

RH Blended Rate

Description / Help Text:  A formula that calculates the blended rate by dividing the total Forecasted hours by the total Forecasted Amount.

Type:  Formula – Currency

Field Name:  Calculated_Blended_Rate

Length:  16

Decimal Places:  2

FormulaIF(RH_Total_Hours__c > 0, RH_Total_Amount__c / RH_Total_Hours__c , 0)

API Name:  Calculated_Blended_Rate__c

Have more questions?

Contact Us