I am trying to (1) sum 6 sensors and (2) sum the same 6 sensors and multiply by total by the value of a 7th sensor. My sensors are all Phidgets and are named &1, &2, &3, &4, &5, &6, &7. The formula I put in the calc column is +&1+&2+&3+&4+&5+&6 for the first calculation and +&7*(+&1+&2+&3+&4+&5+&6) for the second calculation. But it isn't working. The fields are set up in the database okay but the values inserted don't have any obvious bearing on the values of &1-&7.

What am I doing wrong?

I am familiar with thread http://board.homeseer.com/showthread...46001&t=138325

More generally what are the rules for calculations and is there a reference for them. For example, are parentheses allowed like I have used? Is division allowed?

Thx

What am I doing wrong?

I am familiar with thread http://board.homeseer.com/showthread...46001&t=138325

More generally what are the rules for calculations and is there a reference for them. For example, are parentheses allowed like I have used? Is division allowed?

Thx

## Comment