244
Hi,
Just wondering for right approach,
I am trying to set an optionset(State) value based on other optionsetvalue(Country)
If Country is 77 set state as 18 else if country is 3 set state as 180 else null
IF((S1=77),18,IF((S1=3),180,null)).
This is failing with error incorrect number of function parameters, incorrect function parameter type. Any help with this?
Is this not the code?
IF((S1=77),18,IF((S1=3),180,null))
And I had tried one more thing as well with select case
SELECTCASE(S1 , "=77~18 | =3~ 18" )
S1 is an optionset of Source based on this I am trying to set option set in destination.
if (S1 == 77 or S1= 3)
{
set destination optionset to 18
}
else nothing.
If you are able would you please display your code.
Need more information.
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
