AnsweredAssumed Answered

calculated field get text from field based on dropdown

Question asked by Joe Carter on Oct 2, 2016
Latest reply on Oct 2, 2016 by Joe Carter

Hi

 

I want to copy a value from a field based on a dropdown.  The statements below work if there is only one in the formula box but I need all 4.  Can anyone explain what I am doing wrong and any pointers on how to do it.

 

ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),1),$one_user_price,"0.00")

ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),3),$three_users_price,"0.00")

ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),4),$four_users_price,"0.00")

ifElse(equal(getDropdownValue("ce_no_of_users_list",$no_of_users),"Unlimited"),$unlimited_price,"0.00")

Outcomes