Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to write an expression for the below Associate dimension that will display all agents except the agents that work for Simon who do not reside in Florida. If an associate works for another manager then I do not care where they live. Below in red is an example of the results that I am trying to produce:
Thanks in advance!
Manager | Associate | State | Production |
---|---|---|---|
Simon | Jan Harlow | LA | $300 |
Bob | Frank Smith | CA | $2800 |
Joe | Dan Ly | TX | $250 |
Simon | Bill Allen | FL | $700 |
Joe | James Mint | NV | $1200 |
Simon | Donna Spelding | FL | $800 |
If
=if(not(Manager='Simon' and State <> 'FL'),Associate)
Hi,
=if(Manager<>'Simon' and State <> 'LA',Associate)
Rebeca
If Production is a expression. Use a straight table and make your expression
Sum({$<Manager-={'Simon'}, State-={'<>FL'}>}Production)
This is helpful but the expression isnt removing the associates who work for Simon that do not live in FL.
Hi! Thanks for your response but I tried this expression and it removes all of Simon's associates. I just want to remove the ones who work for Simon that do not work in FL. Thanks again!