Dynamic Component attribute question  Topic is solved

Dynamic Component attribute question

Postby iclifton » Thu Mar 26, 2015 2:32 pm

My question is probably a simple one. If i create an attribute to return the cost of an item based on the model number, which i already have set up in a pull down list. When i use the =if formula, i can only go out 3 cost. i have eight model numbers. Is there a different formula that i can use or am i doing something wrong.
0

iclifton 
Premium Member
Premium Member
 

Re: Dynamic Component attribute question  Topic is solved

Postby pcmoor » Thu Mar 26, 2015 11:21 pm

you can use nested if statements, however it is best to use the choose function, based on the dropdown index. CHOOSE(index,value1,value2,...valueN)

cost =choose(drop,$12,$15.....$n)
drop item 2 (where the value =2)

or if value of drop is some function or not a consecutive integer,
then use OPTIONINDEX("attributeName")
within the choose function

cost =choose(optionindex("drop"),$12,$15.....$n)

the number of choices = numder in dropdown
0

pcmoor 
 

Re: Dynamic Component attribute question

Postby iclifton » Fri Mar 27, 2015 2:39 pm

Thank you pcmoor. i was able to use =CHOOSE(OPTIONINDEX. It gave me the result i was looking for. Thanks for the help!
0

iclifton 
Premium Member
Premium Member
 

SketchUcation One-Liner Adverts

by Ad Machine » 5 minutes ago



Ad Machine 
Robot
 



 

Return to Dynamic Components

Who is online

Users browsing this forum: No registered users and 3 guests

Visit our sponsors: