InfoPath Dev

I have a drop down box (Choice B) with filtering applied to populate Calc fields.

What I am trying to do is get the TOTAL column to do the math based upon the user’s choice in the B column. 

For example, if the user selects “Windows” the expression box will know to multiply Calc 2 and Calc 3 and multiply by the quantity from another field. In this example, let’s say it’s 2.

If the user selects Lynx, it will know to calculate Calc 1 x Calc 2 divide by Calc 4 x Qty of 2.

If the user selects Unix it will add Calc 3 + Calc 4 x Qty of 2.

How should I go about writing this? I’m very new to formulas.

Update: So I have a working formula to do the math, but I don't know how to edit it to filter the formulas to trigger based upon the user selected choice from the Choice B column.

So, it seems to me that it would be best to have the TOTAL field use a default value so you don't have to write a bunch of rules. But your formula varies according to the selection - so that makes a default value tough.

I'd put the rule on the ChoiceB field, and then I'd put it on the Qty field as well, since it also comes into play (unless it isn't something the user can change?)

Good morning, apologies for my delayed response... life happens as they say :) 

You are correct. The total field needs to reflect different calculations based upon the user's selection from the ChoiceB field. They are different formulas. The qty field is not editable (it is a running total from selections made eariler in the form).

Being new to writing these things, I was wondering if there is a function such as SUM, CONTAINS or similar, that will allow it to see the ChoiceB field.

Can you please elaborate on what the rule would look like if placed on the ChoiceB field?

Anyone?

Want to attach your sample form? Under the Options tab?

You've got mail! Thank you...

Thank you Hilary!

Looks like my solution will be to add a bunch of rules to the drop box field so that when a user selects an option from the drop down box, it will display the calculated result in the total field.