Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

CalculateTable with If condition

Hi,   I am working on Dynamic row level security. The requirement is, if the Username() is present in Emp_ad then evaluate table 1 expression else evaluate table 2 expression.   1st expression i...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , I doubt you can username in calculate table. But you should be able to use in table inside measure

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak ,

     

    Thanks for your reply. I added username() just to simplify the expression. I am not using username() instead I am using below expression:

    If ( IFERROR(SEARCH("@",USERNAME()),-1) <> -1,

    LEFT(SUBSTITUTE(USERNAME(),"@","-"),SEARCH("-",SUBSTITUTE(USERNAME(),"@","-"))-1),

    RIGHT(USERNAME(), LEN(USERNAME())-9)