Forum Discussion

harib's avatar
harib
Icon for Post Patron rankPost Patron
6 years ago

Conditions for Columns

Hi All,   I have senario like below table  .    Main Table  SNO      MG      MU      MP     LG      LU       Percentage1        Percentage2 1            XX       AA       BB      CC      DD    ...
Need Help
Tips and Tricks
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

harib ,

 

Create calculated column like below:

Column 1  = if(OR(HASONEVALUE(Sheet7[MG]),HASONEVALUE(Sheet7[MU])),"Yes")
Column2 = if(OR(HASONEVALUE(Sheet7[LG]),HASONEVALUE(Sheet7[LU])),"No")
 
Please give Thumbs up for support and accept this as a solution if it helps you!
  • harib's avatar
    harib
    Icon for Post Patron rankPost Patron
    6 years ago

    Tahreem24 

    If i would like to add one more column (MP), when i add MP Column, syntax is showing wrong. Can u pls let me know.

     

    Thanks

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      6 years ago

      harib ,

       

      What would be the business logic for MP column?

       

      Thanks!