InfoPath Dev

Hi,

I am new to InfoPath and have the foolwing requirement:

 I have a repeating table:

Name    |      Total      |      Hourly   |   Type

Name1 |      20          |                   |   Type1

Name2 |      44          |                   |   Type2

Name3 |      88          |                   |   Type2

 And 3 other fields

Total 1 = 55

Total 2 = 66

Total 3 = 77

What I am trying to achive is the following within the Hourly field in the repeating table:

Name1  = total / (total 1 + total 2)

Name2  = total / (total 1 + total 2 + total 3)

Name3  = total / (total 1 + total 2 + total 3)

Which are conditional on the Type.

What would the best way of achiving this?

I've been round and round in circles.

Thank you in advance.

Thank you very much for your quick response.

 I've been through your guide step by step and it doesnt seem to be populating the Hourly field.

The setup at the moment requires the "Run Query" button to be pressed to populate the form.

Could this be the reason it isn't populating the Hourly field??

 Thank you.

Didn't you get the ‘Hourly’ value even for ‘Type1’?

First enter all fields then enter the value in Type.

Let me know if you still not get the value.

Not even for Type1.

But does it require the user to interact with the feilds before the rule fires.

I'm just thinking maybe it would be better doing the calculations in code behind within Visual tools for applications??

Thank you.