Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure or Calculated Column adding +1 per condition met

Hi all,   Per row, I want to check how many conditions the associated data meets.   E.g. if I have the following table People:   Name Cash Eye Color Shoe Color Hair Color John 20 Br...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , not very clear

    create a new column =if( [cash] > 50 && [eye color] = "Green",1,0) + if( [cash] <10 && [eye color] = "Brown",1,0) + if( [Shoe Color] "Yellow" && [eye color] = "Green",1,0)
    + if( [Shoe Color] "Brown" && [eye color] = "Brown",1,0)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Is this what you're looking for?