Newbie Questions

Re: Help with figuring market share

Kerbob97 — Wed, 17 Jan 2007 07:29:48 GMT

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.

Re: Help with figuring market share

shailaja — Wed, 17 Jan 2007 05:14:17 GMT

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!

Help with figuring market share

Kerbob97 — Tue, 16 Jan 2007 19:48:39 GMT

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.