4 Replies Latest reply on Jan 19, 2017 12:38 AM by Fabrizio Laconi

    Could somebody help me with this statement?

    Fabrizio Laconi

      Hi

       

      Could anyone help me with the below statement?

       

      Specifically the: ELSE "Other" part... I would like the Other to not show at all... If I just leave it out it still appears as Null. My boss thinks that Other/Null is confusing and should not appear in the table.

       

      Many thanks,

       

      Fabrizio

       

       

      IF CONTAINS(UPPER([Property Rate Name]),"EXCITE") THEN "Excite Holidays"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"AGODA") THEN "Agoda"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"BOOKING.COM") THEN "Booking.com"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"EXPEDIA") THEN "Expedia"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"WOTIF") THEN "Expedia"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"HOTELS.COM") THEN "Expedia"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"ORBITZ") THEN "Expedia"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"YATRA.COM") THEN "Yatra.com"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"ELONG") THEN "Elong"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"CTRIP") THEN "Ctrip"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"MAKEMYTRIP") THEN "MakeMyTrip"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"MAKE MY TRIP") THEN "MakeMyTrip"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"CLEARTRIP") THEN "ClearTrip"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"CLEAR TRIP") THEN "ClearTrip"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"QUNAR") THEN "Qunar"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"VERYCHIC") THEN "VERYCHIC"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"17U") THEN "17U"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"RAKUTEN") THEN "Rakuten"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"TRAVELGURU") THEN "TravelGuru"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"GOIBIBO") THEN "Goibibo"

      ELSEIF CONTAINS(UPPER([Property Rate Name]),"FLIGHT CENTRE") THEN "Flight Centre"

      ELSEIF CONTAINS(UPPER([Property Rate Code]),"Y-GTA") THEN "gta"

      ELSEIF CONTAINS(UPPER([Property Rate Code]),"Y-HRS") THEN "HRS"

      ELSEIF CONTAINS(UPPER([Property Rate Code]),"Y-") THEN "Other OTA"

      ELSE "Other"

      END