7 Replies Latest reply on Nov 20, 2018 12:44 AM by sasidhar manelluru

    Table calculation for code the list of countries

    sasidhar manelluru

      Hi Team,

       

      can you please help me on a calculation field to find the country list

       

      ex: 1.Origin country we have "India" and in Destination country field we have any other country

             2. Origin country we have "Other country" and in Destination country field we have "India".

      3.  Origin country we have "India" and in Destination country field we have "India".

       

      which all fields satisfies this condition need to mark as "India" and other need to be mark as " N/A"

       

      i have tried this but its not working .

       

      IF  (([Origin Country] = "IN-India" OR [Destination Country]= "IN-India") OR  ([Origin Country] = "IN-India" AND   [Destination Country]= "IN-India"))

       

       

      THEN "india"

       

       

      ELSE "NA" END

       

         

      Origin CountryDestination CountryIN list
      US-United StatesIN-India
      NZ-New ZealandAU-Australia
      VN-VietnamNZ-New Zealand
      IN-IndiaIN-India
      PH-PhilippinesMY-Malaysia
      PH-PhilippinesIN-India
      IN-IndiaTW-Taiwan
      PH-PhilippinesVN-Vietnam
      PH-PhilippinesIN-India
      KR-Korea (South)NZ-New Zealand
      CN-ChinaIN-India
      IN-IndiaPG-Papua New Guinea
      CN-ChinaIN-India
      AU-AustraliaPG-Papua New Guinea
      IN-IndiaIN-India
      CN-ChinaAU-Australia
      MY-MalaysiaAU-Australia
      ID-IndonesiaAU-Australia
      IN-IndiaNZ-New Zealand
      ID-IndonesiaJP-Japan
      JP-JapanID-Indonesia
      IN-IndiaIN-India
      CN-ChinaID-Indonesia
      IN-IndiaIN-India
      IN-IndiaIN-India
      CN-ChinaAU-Australia
      CN-ChinaAU-Australia
      IN-IndiaAU-Australia
      CN-ChinaNZ-New Zealand
      CN-ChinaIN-India
      IN-IndiaIN-India
      TH-ThailandAU-Australia
      IN-IndiaIN-India
      TH-ThailandAU-Australia
      CN-ChinaAU-Australia
      MY-MalaysiaAU-Australia
      CN-ChinaAU-Australia
      CN-ChinaIN-India
      CN-ChinaAU-Australia
      CN-ChinaIN-India