Simple If Else Calculation

Question & Answer
,
1

I’m trying to use an if else statement along with parameters and I am not sure what is missing.
The goal of the calculation is to use Orig-Ref-Loading Area, where if Orig-Ref-Loading Area = ’ BAY 1’ then it applies my integer parameter. In this case ${CamBayOneSlots}.

There are more bays then just ‘Bay1’ but I can not seem to get itdown.

image
image1908×578 15.2 KB

2

Hi @aaron000000001,

What value do you want to see when the first condition (BAY 1) is satisfied? That’s missing from your calculated field. You need to specify one value for each condition.

3

the value I want everything to be in BAY 1 is 32

4

The correct syntax is:

ifelse({Orig-Ref-Loading Area} = 'BAY 1',  ${CamBayOneSlots}, 'others')

However, you can’t have your else value as text if ${CamBayOneSlots} is an integer. You’ll have to convert ${CamBayOneSlots} to text

5

First convert ${CamBayOneSlots} in text by using tostring and then use this formula