Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need to solve this problem and cant get my head around it,
I have a statight table that looks like this. I need a calculation that shows the value 1 if a single SSN has the value smoke and snuff on a matching date. Ive tryed a if match statment like this but cant get i right
if(Match(Signed,SSN, Rökare and Snusare='1', 1)
SSN | Signed | Smoke | Snuff |
565656 | 2015-07-01 10:38 | 1 | - |
565656 | 2015-07-01 10:38 | - | 1 |
Any ideas?
can we try like:
if(Signed='1' or SSN='1' or Rökare='1' or Snusare='1', 1)
or depend on what you need
if(Signed='1' and SSN='1' and Rökare='1' and Snusare='1', 1)
are u looking for this?
Not really sure how you data is structured, would you be able to prepare a small sample?
Hi,
Shiva's proposed solution seems to show the correct answer, but as Sunny has suggested a small data set or QVW would help, as I would suggest looking at the data model, I would normally expect the to see you example as one line.
SSN | Signed | Smoke | Snuff |
565656 | 2015-07-01 10:38 | 1 | 1 |
Then the set analysis would be easy, or even script a flag.
Mark