Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help needed - count a value row wise

  I would like to add the number of N row wise. How do I do that?   Thanks, Anand
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    Anonymous ,

    I added a column to your original table. No unpivoting.


    Let me know if you have any questions.

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

     

    Summary = If(Original[a] = "Y", 1)+If(Original[b] = "Y", 1)+If(Original[c] = "Y", 1)

//just copy and paste the the first IF, and then change the letter on the rest.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Yes I did that

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

And does that work?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

     

    I haven't tried the one that you posted. But this worked -