Forum Discussion

obriaincian's avatar
obriaincian
Icon for Resolver I rankResolver I
3 years ago

Nested IF AND Statements

Hi All,   I have what seems to be a very simple formula that doesn't seem to be working.   All I want to do is return the workstream DRI Email where the workstream DRI Email = USERPRINCIPLENAME()...
Need Help
obriaincian's avatar
obriaincian
Icon for Resolver I rankResolver I
3 years ago

mlsx4 

 

Yes I had tried it without the && but no luck unfortunately.

mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

obriaincian 

 

But have you tried if the condition is ever met? I mean, with a silly example:

Var User_ = USERPRINCIPALNAME()

RETURN
IF(
    SELECTEDVALUE(Data[Workstream DRI Email]) = User_,
    1,
    0
)

 

  • obriaincian's avatar
    obriaincian
    Icon for Resolver I rankResolver I
    3 years ago

    mlsx4 , yes I have. I just can't figure out why it returns data for both IF statements