There is a similar issue in this question response by @Keigo. https://unmethours.com/question/55005...

"if you want to model the multiple zone and calculate each zone bill later, then you can utilize Zone Air System Sensible Heating Energy and Zone Air System Sensible Cooling Energy in order to calculate the percentage of energy use for each zone....Cooling Coil Electricity Energy (Fan energy too?) needs to be prorated according to the proportion of energy consumption in each zone because the model has only one heat source each for heating and cooling (Furnace for heating and DX Coil for cooling). For central HVAC system, energy fuels (Electricity and NaturalGas) are not consumed in zones, but consumed in the heat source. If you want to charge the consumed energy to each zone, the consumed energy needs to be prorated according to the proportion of energy distributed to each zone. If there are three zones (Zone A, B and C).

Zone A:Cooling Electricity Energy [J] = Cooling Coil Electricity Energy [J] × Zone A:Zone Air System Sensible Cooling Energy / (Zone A:Zone Air System Sensible Cooling Energy + Zone B:Zone Air System Sensible Cooling Energy + Zone C:Zone Air System Sensible Cooling Energy)"

This example is for three zones, but you could apply the same equation and extrapolate to 40 conditioned zones.

Are all 40 conditioned thermal zones in parallel on the supply side of the HVAC system, connected to the same demand side loop that is providing the conditioning equipment (coils, fan etc.)? If not, this equation would not apply. This may not apply for the given HVAC system you are using. Can you post your node diagram from OpenStudio?