Forum Discussion

KWelsh8144's avatar
KWelsh8144
Icon for Helper II rankHelper II
3 years ago
Solved

IF statement with multiple conditions for unique IDs

I'm trying to get an if statement that looks at each unique ID and then meets the following criteria:    Each ID must have Complete = yes, and Type = 20 OR Type = 13 AND 23   The flag column woul...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Try this calculated column formula instead

    Column1 = 1*(or(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Complete]="Yes"&&(Data[Type]=20))),and(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Complete]="Yes"&&Data[Type]=23)),CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[Complete]="Yes"&&Data[Type]=13)))))

    Hope this helps.

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi KWelsh8144 

can you also provide the expected column?

KWelsh8144's avatar
KWelsh8144
Icon for Helper II rankHelper II
3 years ago

FreemanZ sure! i updated the original post. thanks!

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    hi KWelsh8144 

    could you explain how comes 1 for 4 and 6?

     

    • KWelsh8144's avatar
      KWelsh8144
      Icon for Helper II rankHelper II
      3 years ago

      I don't necessary need it that way if it could only show for the conditions that it meets - that's fine as well, but what i was getting at was that, that particular unique ID meets the criteria of the if statement. However, if it would instead only show a 1 for records with a 20 OR 23 and 13, that would work too.