Forum Discussion
Help needed - count a value row wise
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.
NathanielSummary = 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.
Thanks for the solution. However I also want to display all the columns. I mean a,b,c,d,e and the count of N.
Kindly help me with that
Community ChampionAnonymous ,
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.
This works great. However the only problem is that - if every column has N instead of Y, it isn't even displaying that row.
THanks,
Anand!
- Nathaniel_C
Summary = If(Original[a] = "Y", 1)+If(Original[b] = "Y", 1)+If(Original[c] = "Y", 1,0)
Add a ,0 after the 1 at the end
Yes I did that