Creating a Yes/No column based on other columns

I am looking for some help on a formula to create a column which says if a booking is with or without children/infants

There are two columns, one called children and one called infants, that shows the total number of children/infants in the booking.

It's something along the lines of this but I can't quite figure it out, any help much appreciated 🙂

If (children) or (infants) >0

THEN "With children"

ELSE "Without children"

END

Datasets

Reporting

Data Investigation

Accepted answers

Jonathan-Sherman

Hi @beadyeyesbb,

It looks as though your [CHILDREN Pax] and [Infants Pax] fields are perhaps strings and not numeric. Could you try the following formula:

IF ToNumber([CHILDREN Pax]) > 0 OR ToNumber([Infants Pax]) > 0

THEN "With Children"

ELSE "Without Children"

ENDIF

If this solves your issue please mark the answer as correct, if not let me know!

Regards,

Jonathan

All comments

markcurry

Either of the following formulas should work for you...

IF [Children] > 0 OR [Infants] > 0 THEN
"With Children"
ELSE
"Without Children"
ENDIF

IF [Children] + [Infants] > 0 THEN
"With Children"
ELSE
"Without Children"
ENDIF

fmvizcaino

Hi @beadyeyesbb ,

The correct way to use the condition in order to get your expected results is as following.

If [children]>0 or [infants] >0

THEN "With children"

ELSE "Without children"

END

Best,

Fernando Vizcaino

beadyeyesbb

Thank you for response!

It says malformed IF statement.

fmvizcaino

Would you be able to share a printscreen of your error?

kirans666

The below code should help.

IIF (([Children] > 0 OR [Infants] > 0),
"With Children",
"Without Children")

beadyeyesbb

sure, does this help?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703