Formula query

[JoseGarcia]

Hi all, 

Formula below is not giving any results when there is no selection made.
I need: when no selection is made, the result to display an average.
Can anyone help?

sum([1ENV08]+[ENV22 ]) /
([1HS11 ]+[1HS06])

As always, thanks a million.

Jose

[Taoufiq_Zarra]

@JoseGarcia  can you share a sample data and the expected output ?

[JoseGarcia]

here's a sample table:

the values should return three decimals: 0.0096 (example)

Site	Energy consumption - MWh of natural gas	Energy consumption - MWh of electricity	E+C hours consolidated
Golders Green	309.83	67.17	39,130.50
Manchester TCC	133.00	215	78,777.67
Wembley TCC	103.00	141	25,322.50
Morden	97.13	52.72	18,260.00
Glasgow TCC	50.00	167	24,324.40
Widnes TTC	19.46	71.7	29,392.40
Oxley TCC	17.70	107.2	33,538.33
Liverpool TCC	7.90	53.7	11,955.00
Chester TCC	6.24	64.8	18,338.67

[JoseGarcia]

this a a month data sample

[Taoufiq_Zarra]

@JoseGarcia  and the forumula ? the fields [1ENV08], [ENV22] ,... ?

sum([1ENV08]+[ENV22 ]) /
([1HS11 ]+[1HS06])

[JoseGarcia]

Taoufiq, 

Avg
(Sum([1ENV08 Energy consumption - MWh of natural gas]+[ENV22 Energy consumption - MWh of electricity])/
([1HS11 Contractor hours worked]+[1HS06 Employee hours worked]))