Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to restrict my dimension to only show 2 measures.
Using this formula, but I believe I am missing the trick here.
Could anyone assist?
=If([CC$.risk_rating]='amber', + [CC$.risk_rating]='red', [CC$.risk_rating])
Thanks a million.
Jose
@JoseGarcia Try like:
=If([CC$.risk_rating]='amber' OR [CC$.risk_rating]='red', [CC$.risk_rating])
@JoseGarcia Try like:
=If([CC$.risk_rating]='amber' OR [CC$.risk_rating]='red', [CC$.risk_rating])
It worked, thanks a million.
Just could not remember the OR 🙂