Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
i want exclude a value with expresion like this on my dimension named Myvalue
if(mydate >=201802 and Myvalue <>'xxxxx' ,Myvalue) =>FINE OK
if(mydate >=201802 and Myvalue <>'xxxxx' ,Myvalue,i want here all my dimension without exclusion) =>FINE KO
but i cant' make an else condition it doesnt work fine
Hi,
what is the logic behind filtering a dimension using an expression and use an else part to not filter that dimension ?
what is the exptected output ?
May be try
if(mydate >=201802 ,Only({<MyValue={'*'}-{'xxxxx'}>} Myvalue) ,MyValue)
Thank for your return
But it doesn't work.
Can you post some sample data to work on? And your expected output?