Newer Version Available
Data Gap Filling
| Available in: Lightning Experience and the Salesforce mobile app |
| Available in: Enterprise, Performance, and Unlimited Editions |
Here are the calculated fields:
Input fields
-
Building Energy Intensity Value (BldgEnrgyIntensityVal)
-
Annual Intensity Value (kWh/m2) (AnnualIntensityValueInKwhM2)
-
-
Stationary Asset Carbon Footprint (StnryAssetCrbnFtprnt)
-
Regional Building Energy Intensity (RegionalBldgEnergyIntensity)
-
Building Energy Intensity (BuildingEnergyIntensity)
-
Occupied Floor Area (OccupiedFloorArea)
-
-
Stationary Asset Energy Use (StnryAssetEnrgyUse)
-
Total Fuel Consumption (kWh) (TotalFuelConsumptionInKwh)
-
Start Date (StartDate)
-
End Date (EndDate)
-
Calculations
-
If Fill Method = Regional Building Energy Intensity, then
Fill Data = StnryAssetCrbnFtprnt.RegionalBldgEnergyIntensity.BldgEnrgyIntensityVal (for the fuel type).Annual Intensity Value (kWh/m2) * Occupied Floor Area/365 * data gap duration
-
If Fill Method = Building Energy Intensity, then
Fill Data = StnryAssetCrbnFtprnt.BuildingEnergyIntensity.BldgEnrgyIntensityVal (for the fuel type).Annual Intensity Value (kWh/m2) * Occupied Floor Area/365 * data gap duration
-
If Fill Method = Previous Year Daily Average, then
Fill Data = SUM(StnryAssetCrbnFtprnt.PrevYrAnnlCarbonFootprint.StnryAssetEnrgyUse.Total Fuel Consumption (kWh)) / SUM(StnryAssetCrbnFtprnt.StnryAssetEnrgyUse.End Date - StnryAssetCrbnFtprnt.StnryAssetEnrgyUse.Start Date) for the selected fuel type
-
If Fill Method = Current Year Daily Average, then
Fill Data = SUM(StnryAssetEnrgyUse.Total Fuel Consumption (kWh)) / SUM(StnryAssetEnrgyUse.End Date - StnryAssetCrbnFtprnt.PrevYrAnnlCarbonFootprint.StnryAssetEnrgyUse.Start Date) for the selected fuel type