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

All responses (5)

Answers (0)

DPerko 417 on at

Like (0)

Report

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

Todd-

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

Dan
DPerko 417 on at

Like (0)

Report

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

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
atajjo 509 on at

Like (0)

Report

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

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.
ToddB on at

Like (2)

Report

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

Hi Dan,

I saw the below in LCS regarding this:
WillWU 22,352 on at

Like (0)

Report

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

Moved to SCM forum.