kBTU/SF e (AD): IIf([Numbers Combined]![Product_Code]="E",[Numbers Combined]![Usage]*3413/1000/[Benchmarking]![FacilitySquareFeet])
and here's the second one:
kBTU/SF/yr Therm nrml(AF): (((IIf([Numbers Combined]![Product_Code]="G",([Numbers Combined]![Usage]*7122)/[Numbers Combined]![Degree Days]))*100)/[Benchmarking]![FacilitySquareFeet])
Something I noticed is that the IIF() is incorrect. The syntax is:
IIf(expr, truepart, falsepart) .......... Note that ALL 3 parts are required.
You are missing the falsepart in both functions.
Here is how I build complicated IIF() statements.
--Start with the function:
kBTU_E: IIf(expr, truepart, falsepart)
--Enter in the expr part (the condition that evaluates to TRUE or FALSE)
Code:
kBTU_E: IIf([Numbers Combined]![Product_Code]="E", truepart, falsepart)
--Add the truepart:
Code:
kBTU_E: IIf([Numbers Combined]![Product_Code]="E", [Numbers Combined]![Usage]*3413/1000/[Benchmarking]![FacilitySquareFeet], falsepart)
--Then add the falsepart . In this case, anything other that "E" should be zero. So:
Code:
kBTU_E: IIf([Numbers Combined]![Product_Code]="E", [Numbers Combined]![Usage]*3413/1000/[Benchmarking]![FacilitySquareFeet], 0)
Now the second formula.
--Start with:
kBTU_G: IIf(expr, truepart, falsepart)
--Enter in the expr part (the condition that evaluates to TRUE or FALSE)
Code:
kBTU_G: IIf([Numbers Combined]![Product_Code]="G", truepart, falsepart)
--Add the truepart:
Code:
kBTU_G: IIf([Numbers Combined]![Product_Code]="G", (([Numbers Combined]![Usage]*7122) / ([Numbers Combined]![Degree Days])*100)/[Benchmarking]![FacilitySquareFeet], falsepart)
--Then add the falsepart . In this case, anything other that "G" should be zero. So:
Code:
kBTU_G: IIf([Numbers Combined]![Product_Code]="G", (([Numbers Combined]![Usage]*7122) / ([Numbers Combined]![Degree Days])*100)/[Benchmarking]![FacilitySquareFeet], 0)
(In this second formula, you had a couple of parenthsises in front of the IIF(); those parenthsises were in the wrong place.)
Then you can do like Robeen said:
Code:
TotalBTUs: kBTU_E + kBTU_G