Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Instead of writing :
If(Left(MyFields,1) = '4' OR Left(MyFields,1) = '5' OR Left(MyFields,1) = '6'
how can I do it more simply/ properly?
This does not work:
Left(MyFields,1) IN ('4','5','6')
Thank you !
hi @Aurél
if you want to build a measure you could try
sum({< MyFields={"1*","2*","3*"} >} sales)
or
sum({< MyFields={"1*"}+{"2*"}+{"3*"} >} sales)
for an IF condition you could try wildmatch
=if(wildmatch(MyFields,'1*','2*','3*'),MyFields)
Hope this helps.
Best,
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁
hi @Aurél
if you want to build a measure you could try
sum({< MyFields={"1*","2*","3*"} >} sales)
or
sum({< MyFields={"1*"}+{"2*"}+{"3*"} >} sales)
for an IF condition you could try wildmatch
=if(wildmatch(MyFields,'1*','2*','3*'),MyFields)
Hope this helps.
Best,
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 😁
this is my attempt:
match(left(MyFields,1),4,5,6)>0;
It's not a mesure but it's a test in reload script.
I's OK with :
=if(wildmatch(MyFields,'1*','2*','3*'))
Thank you !