Creating a Yes/No column based on other columns

[beadyeyesbb]

Hi 

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

[beadyeyesbb]

I have tried changing to that but it still isn't working 😞 

[Jonathan-Sherman · Accepted solution]

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

[beadyeyesbb]

thank you!