ELSE IF simple but not working

[boardburner]

Using CR11
Just trying to make a small quote form.
I have established parameters for Part # and Qty.
This formula should return to my detail section the quantity of parts that is associated with part #1,2 or 3.
But not working ! Brain dead need suggestions possibly different approach. Everything works fine until I add the first "else". I need the user to enter Part #'s and the Quantities to get the costing to generate the quote report.

Formula; @QuoteQty

if ({ipart.ippart}={?Part #1})then {?Qty1}
else
if ({ipart.ippart}={?Part #2})then {?Qty2}
else
if ({ipart.ippart}={?Part #3})then {?Qty3}

Thanks
G

 

[Turkbear]

Hi,
How are you using that formula to control the record selection?..You do not seem to be referencing any Data fields..






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[boardburner]

This is the selection expert formula;
{ipart.ippart} in [{?Part #1}, {?Part #2}, {?Part #3}]

This is the part # data; {ipart.ippart}
When the user hits "F5" they have the option to enter various part # parameters and an associated quantities. as {?Part #1},{?Part #2}, etc. and a quantity as {?Qty1},{?Qty2}, etc.

I pull @QuoteQty into the detail section to use for calculation.

 

[lbass]

What error message are you getting and where is the cursor when you get it?

-LB

 

[boardburner]

Solved !!!
Knew it had to be something simple.
I didn't have the parameter type for the "Qty" set to a "number".

Thanks Anyway
G