So if the first segment:

[tblTempleFuelcellOnly]![I

...evaluates to 100,

...Then 100*8=800

So you can see here that this formula may not be the best technique to get values that will always add up to100%.

The formula to get a percentage of each part to the whole (100%) is

each number divided by the Total:

Amount

459

846

121

Here the total is: 1426

So,

459/1426=32.19%

846/1426=59.33%

121/1426=8.49%

So, the sum of the percents will always be 100%

32.19%

59.33%

8.49%

Make sense?

It would seem that your formula here would have to do something similar, so you will have to explain what each of those "factors" represents...

JeffCoachman