InfoPath Dev

I am basically trying to do a simple formula to determine share of business.

I have several drop down boxes, set to text format, with assorted selections. If the product selected is one of two of our brands, I want it to affect the formula. IF it is not, then I do not want it to count.

For VALUE If Value= A or B, then VALUE =1, If No A or B, then Value=0

This value is then plugged in to a formula that will total up my share and then determine the percentage in another box.

However, the problem I am having is that when I select something, it just goes back to being a "select..." or the other value.

Originally, I just set the format as a whole number, and set the values =1, for my two products; and the other products as =0. This worked, but it would show as only one of my products, and then the other products would change to another value as well.

Any suggestions would be greatly appreciated.

Hello Kerbob97 and Welcome to Forums,
I think your problem resembles the problem specified in this forumhttp://www.infopathdev.com/forums/topic.asp?TOPIC_ID=4108 if that is correct than we cannot have same value for two different display names

Hope this helps!

That is pretty similar to my problem. Is there any sort of workaround?

Here are my ideas:

-Set up rules that will run a part of the formula for each part that is true?

-Is there some way to hide a formula or box, so that only the dev can see it and the end user can not? If so, I can just make this run quick and ugly by totaling up for each product

-Fist of doom through my LCD and head to some tropical beach and work as a bartender in some dive bar

:) Seriously though, any help would be appreciated.