Newbie Questions

Re: Need guidance to write formulas based upon a choice (drop down) selection

TxSteve — Tue, 14 Feb 2012 19:06:31 GMT

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.

Re: Need guidance to write formulas based upon a choice (drop down) selection

TxSteve — Tue, 14 Feb 2012 17:42:04 GMT

You've got mail! Thank you...

Re: Need guidance to write formulas based upon a choice (drop down) selection

Hilary Stoupa — Tue, 14 Feb 2012 17:19:03 GMT

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

Re: Need guidance to write formulas based upon a choice (drop down) selection

TxSteve — Tue, 14 Feb 2012 17:09:30 GMT

Anyone?

Re: Need guidance to write formulas based upon a choice (drop down) selection

TxSteve — Mon, 13 Feb 2012 15:00:28 GMT

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?

Re: Need guidance to write formulas based upon a choice (drop down) selection

Hilary Stoupa — Thu, 09 Feb 2012 21:13:03 GMT

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?)

Re: Need guidance to write formulas based upon a choice (drop down) selection

TxSteve — Thu, 09 Feb 2012 20:58:51 GMT

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.

Need guidance to write formulas based upon a choice (drop down) selection

TxSteve — Thu, 09 Feb 2012 18:28:04 GMT

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

Choice B	Calc 1	Calc 2	Calc 3	Calc 4	TOTAL
Windows		50	100		10,000
Lynx	200	20		14	571.43
Unix			20	15	70

Plus there is another existing field on the form called “Quantity”

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.