Trouble using IF statement in Product Configurator model (to return a TEXT value)

(0) Share

Report

Posted on by DPerko

417

I have written a product configurator model containing subcomponent. I am now trying to write a calculation (if statement) the will return a text value attribute for the subcomponent. What syntax should be used to perform this function? It seems like the if statement is only working to return numeric values.

Here is the example I am trying to solve for: If a user selects either "TB" or "TO" return "TB". If any other selections are made return "00".

I would have assumed if[CCTBO2 == "TB" | CCTBO2 == "TO", "TB", "00"] would have worked but it appears returning text values is where my problem is. (Changing the values returned to integers gets rid of the error.

What is the correct syntax to return text values from an if statement? Any help would be appreciated.

Thanks

Dan

I have the same question (0)

All responses (5)

Answers (0)

WillWU 22,361 on at

Like (0)

Report

Moved to SCM forum.

Was this reply helpful? Yes No
ToddB on at

Like (2)

Report

Hi Dan,

I saw the below in LCS regarding this:

Was this reply helpful? Yes No
atajjo 509 on at

Like (0)

Report

I stumbled upon this issue recently and I can confirm the solution above my post is correct.

Basically instead of returning "TB" you have to return the row number that corresponds to this value in the fixed list (1st row number is 0).

OP please confirm whether this solves your issue.

Was this reply helpful? Yes No
DPerko 417 on at

Like (0)

Report

Thanks for the reply. I ended up opening a ticket with MBS to get the answer. Definitely frustrating that some of these things aren't documented.

Dan

Was this reply helpful? Yes No
DPerko 417 on at

Like (0)

Report

Todd-

Thanks for the answer. Would be nice if this type of information was documented.

Dan

Was this reply helpful? Yes No