Your calculation seems like it should work. Since there aren't any values returning, I'm thinking there's a filter or some other field causing everything to be blank. Are you able to attach your .twbx file here so we can take a look to see what's happening?
It is working like either in destination or origin if India is there then it is working.i need if India is in both sides also I need to mark as india
IF (([Origin Country] = "IN-India" OR [Destination Country]= "IN-India") )Then "India" else "NA" end
Satisfies these two conditions
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"
IF (([Origin Country] = "IN-India" AND [Destination Country]= "IN-India") )Then "India" else "NA" end
Satisfies below condition
Origin country we have "India" and in Destination country field we have "India
But I need both in a single calculation
Is it possible...
I need to mark not only india to india if is having
Thailand to india
India to Singapore
India to india
These three conditions need to satisfy..
Are you able to attach your file? I'm not sure why it's not returning any values when you combine the calculations together. Based just on your syntax, it seems like it should be able to detect whether India is the origin or destination, or whether it's in both (although the second part is redundant since you're already checking the source and destinations for "India").