Forum Discussion

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

New column based on another two columns

Hi all,   I'm trying to create a new column based on the two columns below highlighted in pink.  The new column should say Yes if these two columns have "Yes" and No if one of them is "No". I tri...
Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    ROG Try:

    RETURN IF(Flag8Wk_CNSize = 1 && _8WkSigTest = 1, "Yes", "No")

  • ROG's avatar
    ROG
    4 years ago

    Thanks a million tamerj1  
    I was indeed using a wrong measure. The below worked. 

    8WK CN Size_SigTest =
    VAR _8WkSigTest = IF([CHI_SQUARE_TAKERS_8_WK_ACTIVE] = "Yes", 1, 0)
    VAR Flag8Wk_CNSize = IF([flag_8_wk] = "Yes",1, 0)

    Return IF( _8WkSigTest = 1 && Flag8Wk_CNSize = 1, "Yes", "No")
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Greg_Deckler 
The issue is that ROG is trying to compare a measure of type percentage ( [8 WK Diff %] ) with a text ("Yes"). Better if he advises what is he trying to achieve.

ROG's avatar
ROG
Icon for Responsive Resident rankResponsive Resident
4 years ago

Thanks a million tamerj1  
I was indeed using a wrong measure. The below worked. 

8WK CN Size_SigTest =
VAR _8WkSigTest = IF([CHI_SQUARE_TAKERS_8_WK_ACTIVE] = "Yes", 1, 0)
VAR Flag8Wk_CNSize = IF([flag_8_wk] = "Yes",1, 0)

Return IF( _8WkSigTest = 1 && Flag8Wk_CNSize = 1, "Yes", "No")