Forum Discussion

sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago
Solved

Condition & Counts

Hi All,   Here are the two columns from my source table "Table A"       1) If Column F = Not Assessed or Blank = Not Assessed If Column F = Yes or No = Assessed   2) I need total co...
Help appreciated
sdhn's avatar
sdhn
Icon for Responsive Resident rankResponsive Resident
4 years ago
 Column F
 YES
 NO
 NO
 YES
  
  
  
If Column F = Not Assessed or Blank = Not Assessed
If Column F = Yes or No = Assessed
I have my existing code but not getting values as above.

Your help will be appreciated 

 
Thats I need it. Thanks 
VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

sdhn 

 

Try this:

Column =
SWITCH(
    TRUE(),
    [Column F] = "NOT ASSESSED"
        || [Column F] = BLANK(), "NOT ASSESSED",
    [Column F] = "YES"
        || [Column F] = "NO", "ASSESSED"
)

 

Output:

 

 

 

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/