So I am horrible with If/Then Statements. I am trying to make a new column (vstring) that flags rows that need to be looked at based on what is in two columns.
The Top ZIP Sales ADI column is a vstring and the info in that column will look like this: Palm Springs, CA - 186, Los Angeles, CA - 812, etc.
The Percent of Total Circ by Market column is a double and would read like this: 1 or .022 etc
Here is what I came up with:
IF ([Top ZIP Sales ADI] contains "812") && ([Percent of Total Circ by Market] = 1) THEN "Ok" ELSE "Check" ENDIF
Solved! Go to Solution.
It works! Thanks!